Run a case sensitive SQL query search with explicit collations, inspect current settings, and design an index for repeated exact matches.
ADD FILE in an Availability Group: What Happens on the Secondary Replica
ADD FILE on the primary of an availability group reaches every secondary as a log record. If the same path doesn’t exist on a secondary, the operation fails and data movement is suspended. Here is how to resume it.
SQL SERVER – How to do IF…THEN in SQL SERVER?
How do you write IF…THEN in SQL Server? Use a CASE statement, or IIF from SQL Server 2012. Here are simple examples of both for a .NET developer.
SQL SERVER – A Stored Procedure for Executing SSIS Packages in the SSIS Catalog – Notes from the Field #092
SSIS expert Andy Leonard shares a stored procedure for executing SSIS packages in the SSIS Catalog, from the book SSIS Design Patterns. Notes from the Field #092.
SQL SERVER – Knowing Which Database is Consuming My Memory
Which database is consuming my memory? This query on sys.dm_os_buffer_descriptors counts buffer pool pages per database and page type.
SQL SERVER – Unable to Start SQL – Error: SQL Server Could Not Spawn Lazy Writer Thread
Playing with affinity settings, I broke SQL Server startup with error 17120: could not spawn lazy writer thread. Here is what the ERRORLOG showed and how I recovered.
SQL SERVER – Increase Characters Displayed in Text Results
A reader’s JSON output looked cut off compared to my blog post. Here is how to increase characters displayed in text results using Query Options in SSMS.