Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.
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.







