I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
Survey Answers: A Table Design for Questions and Responses
Store survey answers as typed rows instead of one column per question. Then break the design on purpose to see what it blocks and what it cannot.
KILL WITH STATUSONLY: How Long Will This Rollback Take?
Read KILL WITH STATUSONLY rollback estimates, confirm the target session, avoid repeated kills, and account for accelerated recovery.
Activity Monitor Keeps Freezing: Fix WMI and Permissions
When Activity Monitor keeps freezing, the cause can be a missing SQL permission or a missing WMI permission for the Windows account. This post tests the SQL side on SQL Server 2025, walks through the WMI security fix and explains what CIMV2 means. It also gives a query that reads the same activity without Activity Monitor.
Rebuild All Indexes on a Table in SQL Server: SSMS and T-SQL
To rebuild all indexes on a table, right-click the Indexes folder in SSMS and choose Rebuild All, or run ALTER INDEX ALL with REBUILD. This post checks fragmentation first, rebuilds a demo table and shows what the command does to a disabled index. It also compares REBUILD with REORGANIZE and the options that matter.
SQL SERVER – SQL_NO_CACHE and OPTION RECOMPILE Target Different Caches
OPTION (RECOMPILE) and SQL_NO_CACHE concern different cached objects. A banking customer using MySQL and SQL Server prompted my comparison.
What is Stored in TempDB? – Interview Question of the Week #271
Question: What is Stored in TempDB?
Answer: In my recent conversation my client asked me if I know what is currently stored in their TempDb.