A data file grew over the weekend and nobody owns up. This small demo shows how one extended event tells autogrowth from a manual resize.
SET NOEXEC and PARSEONLY: Checking a Script Without Running It
Use PARSEONLY and NOEXEC to inspect scripts without executing them, understand deferred references, and check existing module dependencies.
SQL SERVER – Interview Questions and Answers – Perspectives of an Author
Today is the first day of year 2012 – Happy New Year!. This blog post is written by my co-author of SQL Server Interview Questions.
SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience
I had very clear idea what my goals were in the book. I believed in unique learning experience. Let us talk about it in today’s blog.
SQL SERVER – A Quick Trick about SQL Server CONCAT function
A quick trick from a Virtual Tech Days demo: adding a string to GETDATE() throws an error. CAST fixes it, and SQL Server 2012 CONCAT does it more simply.
Watermarks for Incremental Extracts
Watermarks for incremental extracts need clear boundaries, durable checkpoints, and a plan for late updates, deletes, and missed rows.
EXISTS vs COUNT: The Right Way to Check If Rows Exist
Need a yes or no? Ask EXISTS. Need a number? Ask COUNT. Here is a small demo that shows why mixing them up can quietly give the wrong answer.