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.
SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance
Shrinking database is bad: it increases fragmentation and reduces performance. Here is a simple example with two tables that shows it step by step.
SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications
Part two of my SQL Server Magazine series is a quick look at SQL Server configuration for performance and the settings I check first with new clients.
SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name
A quick note on DB_ID() and DB_NAME(): how to get current database name and ID, and how to turn a database ID into a name and back again.







