Is a Sort slowing down your running totals? Build an index in partition, order, covering order and watch the Sort disappear from the plan.
SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry
Three new DMVs in SQL Server Denali: sys.dm_server_memory_dumps, sys.dm_server_services and sys.dm_server_registry. What they return, and a question for you.
Certificate-Signed Procedures That Read Server DMVs Safely
Give a developer lock-wait data without handing over a server-wide permission. A signed procedure carries the authority, and an edit takes it away.
Checking for SQL Server Dump Files After a Crash
Did the server really crash, or just restart? Here is how to list dump files, read the error log and protect the evidence before anyone cleans up.
Blocking DELETE Without a WHERE Clause Using a Trigger
A trigger cannot read your statement, but it can count the rows that vanish. Here is a guard that stops a runaway delete, and where it falls short.
A Page of Rows and the Grand Total Count in One Query
One query can give a grid its ten rows and the total for the label. Here is how, plus the empty page trap that catches almost everyone.
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
Is your database Case Sensitive? Find its collation, then look it up in fn_helpcollations() and read the description. A quick answer from my Office Hours.






