Domain Accounts for SQL Server Services - Hi I have installed SQL Server 2017 (RTM-CU12) on a server. When installing I used domain accounts that I have used on...
Nested Subquery vs Correlated Subquery -
Best way to mirror SQL database of customers to our SQL database - We have installed a SQL 2017 database on a Windows 2016 server at our customers (about 20) worldwide. We Installed a...
Query Question - I am some what of a self taught developer and was looking for some guidance if the query I have...
HOW TO USE EXISTS FUNCTION WITH 3 TABLES - Can you Please show me that how can we use EXISTS FUNCTION WITH 3 OR MORE TABLE. Please show me...
WHERE Clause exclusions, best practices. - Hello, I was just wondering if anyone has a good idea on how to implement a set of filters that we...
SQL Service Start before App DBs Drives on line - What happens if SQL starts up from C drive, but it takes 5 minutes before the E and F drives...
Restoring backups overview - I'm all we have at the moment, and I'm trying to learn everything I can about disaster-handling before the event....
recreate a Basic Availability Group question - hi, In the process of changing IPs for one node of a clustered server with databases in a Basic Availability Group...
Always On - I know we can have 4 secondary database using Always on. However, i am little unsure that 4 secondary means...
Query runs slow when executing under the context of a different DB - I am trying to understand this behavior but when I try to use the below code and execute it in...
Slow in the Application, Fast in SSMS. How to force the execution plan generated by SMSS - Hi, This is my second case this week where the same query is fast in SSMS and slow in the application....
Why would SQL Server not run? - I've got SQL Server 2016 Developer Edition installed on my desktop. I don't get in it frequently, I'll admit. However,...
Error 9020 - The log for database failed to grow while shrink in progress. Please retry - Hi - I noticed this entry within the SQL log file this morning. I have checked the DB properties for this...
Can I set TDE Encryption off while my db actively in use? - We have a DB about 45GB (32gb compressed-backed up) that has TDE setup, I need to remove encryption so I...
Always On SQL Server 2012 Enterprise. After failover DB Owner ist lost. - Hello Folks, After a failover of one of my SQL server instances it happends that one specifed database lost its dbowner....
Save the actual execution plan of a SQL statement in a script - I have a script that runs in SSIS from an "Execute SQL Task". One statement that is taking about 1...
Overlapping Date Ranges - Hi there, I have looked in many forums and have been unable to find what I am looking for to get...
Database in Recovery Pending State - One of my databases is in Recovery pending state. I tried to run an Alter command on the database to...
Export memo field to Excel truncates values - I am using MS Access 2007. There are two tables each having a memo column. I have written a IIF statement to...
