A year ago I published my second book, SQL Server Wait Stats. On the first anniversary of SQL Wait Stats book, here are some memories from that journey.
SQL SERVER – Error: Fix – Msg 208 – Invalid object name ‘dbo.backupset’ – Invalid object name ‘dbo.backupfile’
Msg 208, Invalid object name ‘dbo.backupset’, but only in SSMS? A reader’s backup history query failed there while it worked in the app. Here is what was going on.
SQL SERVER – Beginning of SQL Server Architecture – Terminology
Beginning SQL Server Architecture: my friend Anil Kumar explains the basic terms and the main parts, the Relational Engine, Storage Engine and SQL OS.
SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video
Tired of writing one INSERT per row? This SQL in Sixty Seconds video shows three methods to insert multiple rows into a single table.
SQL SERVER – A Brief Note on SET TEXTSIZE
Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.
SQL SERVER – Answer – Value of Identity Column after TRUNCATE command
Seed 11, reseed to 1, then TRUNCATE: what comes next? Here is the answer on the identity column after TRUNCATE, with the script and reader comments.
What to Collect When SQL Server Is Slow
Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.