Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
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?
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.
Schema Discovery for JSON Columns: Listing Every Key With OPENJSON
Use schema discovery on JSON columns to count keys and types, inspect nested objects, and find missing required paths with guarded input.
Query for CPU Pressure: Sample the Scheduler Queue
To sample the scheduler queue, read the runnable counts of every scheduler eight times, one second apart, and compare the result with a baseline. This post shows the queue on a quiet server and again while more busy sessions than schedulers run. It reads the spread, the streak and the average that tell pressure from noise.