A view over yearly tables only skips the years it does not need while the CHECK constraints are trusted. Here is how to see it, break it and fix it.
SQL SERVER – Effect of SET NOCOUNT on @@ROWCOUNT
Does SET NOCOUNT change @@ROWCOUNT? I ran a quick demo in a session and ten hands went up before I even hit execute. The script and what it shows.
Storing Email Addresses: Length, Case and Unique Keys
Two accounts for one customer usually means nobody wrote down the case rule. Build the table, break each rule, and see what the database can promise.
Listing Server Logins Not Mapped to Any Database User
A login with no database user is not automatically unused. Build the report, compare by SID, and check server roles before you touch anything.
SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server
A PowerShell way to get a list of fixed hard drives and free space on server: MVP Ravikanth’s short script with Get-WmiObject and Win32_LogicalDisk.
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG() without Using SQL Server 2012 Analytic Function
Readers found five ways to simulate LEAD() and LAG() without the SQL Server 2012 analytic functions. This post shows each solution with its author, runs all five on SQL Server 2025 and compares the rows with the real functions. Four return the same ten rows and one adds a rule of its own.







