How do you list all the clustered and nonclustered indexes of your table, including columnstore? Here is the script I use in my performance health checks.
SQL SERVER – Log Shipping Monitor Not Getting Updated
The log shipping monitor stopped updating last_backup_file and last_backup_date for the primary, while every job ran fine. Here is how I traced it.
SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?
A puzzle with TEXT columns: UNION ALL works fine, but UNION produces error. Can you tell why? The hint is in how UNION removes duplicates.
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
Slow Filestream Data Cleanup can follow deletion when files are still ineligible for garbage collection. One customer was running out of space.
How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154
A workshop customer suspected one of their queries used too much memory. Here is the script I gave them to list running queries with Memory Grant and plan.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.
How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.