Signal wait stats show how long a SQL Server query sat ready to run, waiting in line for a CPU. On Night 2 at the Clipboard Diner, the potatoes arrive on time and the Garden Hash waits anyway. Then two queries split your server’s waits into the CPU part and the resource part.
Wait Stats Basics: How Waits Work in SQL Server
Wait stats basics start with one idea: a query in SQL Server is always either working or waiting. On Night 1 at the Clipboard Diner, one plate of Garden Hash shows the three states every query moves through. Then two queries show the same thing on your own server.
SQL SERVER – Denali – SEQUENCE is not IDENTITY
SEQUENCE is not IDENTITY. A reader asked about the difference: identity belongs to a single column, while a sequence does not depend on any table.
SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE
A quick introduction to SEQUENCE in SQL Server Denali: create a sequence with start, increment and max values, then fetch numbers with NEXT VALUE FOR.
SQL SERVER – Reducing Page Contention on TempDB
Page Contention on TempDB needs an identified allocation wait and server version. I check both before recommending legacy trace flags.
FOR XML PATH: Decode Escaped Text Through TYPE
FOR XML PATH escapes reserved characters. Use TYPE and scalar extraction to recover text instead of manually replacing entity spellings.
SQL SERVER- Differences Between Left Join and Left Outer Join
Is there any difference between LEFT JOIN and LEFT OUTER JOIN? A reader asked, and here is the short answer: none at all, they are the same.