Error 1060 says the rows for a TOP or FETCH clause must be an integer. I tracked down its cause in a friend’s 10000 line stored procedure and fixed it.
SQL SERVER – Identify Last User Access of Table using T-SQL Script
How do you find the last user access of a table? A question at TechEd India 2013 led to this quick DMV script. Keep in mind the data resets on restart.
SQLAuthority News – How to Avoid Procrastination – Professional Development #001 – Video
The first video in our professional development series, led by Nupur Dave, is about how to avoid procrastination and stop putting things off.
Query Store Hints: Fixing a Query Without Touching Its Code
Apply query store hints to a vendor query without code changes, verify failures and plan behavior, then clear the hint after the real fix.
Masked Values: What Dynamic Data Masking Does Not Hide
A masked column shows zeros, but a user with SELECT can still filter, sort and guess the real values. Here is the proof and the fix.
Does Column Order in CREATE TABLE Change How Rows Are Stored?
Someone wants to reorder columns to shrink rows. I measured it on SQL Server 2025, and the answer is mostly no, with one small exception worth knowing.
Reading Pending I/O Requests During a Storage Slowdown
Sample pending I/O requests during PAGEIOLATCH or WRITELOG stalls, map each request to a file, and share timed evidence.