Hello Analytic Functions
SQL Server 2012 CTP 3, formerly known as SQL Server Code Name “Denali”, introduces a new set of T-SQL functions …
Category Archives: Did you know
Performance benchmarking: Explicit vs Implicit Transactions
Benchmarking… The single most important word in Performance Tuning. Without an established benchmark, you really don’t know when to actually …
PREEMPTIVE_OS_GETPROCADDRESS: Are you confusing me?
PREEMPTIVE_OS_GETPROCADDRESS is a new wait type that was introduced in SQL Server 2008 to track time taken by GetProcAddress to …
Statistics Auto Update may not be automatically the best choice
I had written a post a while back stating how DBREINDEX and ALTER INDEX treat the statistics update differently for …
Cache files–Why are you increasing in size?
Management Data Warehouse provides a mechanism to collect Perfmon and DMV outputs and store them in a SQL Server database …
