Learn how to create stored procedure code with parameters and NOCOUNT, then review security, plan reuse, and parameter-sensitive plans.
SQL SERVER – System procedures to know SQL Server Version
There are many ways to know SQL Server version, but did you know two system procedures, sp_server_info and xp_msver, also return it?
SQL SERVER – Find the Growth Size for All files in All Databases
Auto growth should be a safety net, not a routine. Here is a script to find the growth size for all files in all databases and spot risky 10% settings.
SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073
Indexes do not always improve performance. Kathi Kellenberger explains why duplicate and overlapping indexes are a mistake to avoid.
SQL SERVER – Knowing Nested Transactions Behavior with SQL Server
Does SQL Server start a new transaction for every BEGIN TRAN inside another? I show nested transactions behavior with a simple demo for a reader.
SQL SERVER – Backup and Restore Behavior of ReadOnly Filegroup Databases
How do backups behave for a database with a ReadOnly filegroup, and does a restore keep that setting? I walk through it with simple T-SQL scripts.
Interview Question of the Week #012 – Steps to Restore Bak File to Database
Restore bak file backups safely with header and file inspection, complete Windows paths, conditional access changes, and recovery options.
SQL SERVER – Trivia – Days in a Year
A friend was asked in an interview how to find the days in a year efficiently. Here are the T-SQL methods I tried, plus a small quiz for you.
SQL SERVER – Add Node in Cluster – Rule “Node and cluster edition match” failed
Running AddNode on the second cluster node failed with the rule Node and cluster edition match. Here is what the setup logs revealed and how to solve it.










