Review T-SQL habits that hide intent or create avoidable work, including SELECT star, NOLOCK, row loops, and functions on filtered columns.
Load Into a Heap or a Clustered Table: Which Bulk Load Wins
Loading a heap and indexing it afterward only moves the work. Time the whole pipeline before you pick a winner.
Server Settings Worth Checking on Any New Instance
Review SQL Server configuration for memory, parallelism, tempdb, file growth, and backups before a new instance becomes a production surprise.
SQL SERVER – Puzzle to Win Print Book – Functions FIRST_VALUE and LAST_VALUE with OVER clause and ORDER BY
Win a print book: a puzzle on how FIRST_VALUE and LAST_VALUE change with the OVER clause and ORDER BY, based on a question from Nilesh Molankar.
SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
Why does LAST_VALUE change on every row? It is not a bug. The window frame explains it, and ROWS BETWEEN UNBOUNDED PRECEDING and FOLLOWING fixes it.
SQL SERVER – Introduction to FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012
An introduction to FIRST_VALUE and LAST_VALUE, new analytic functions in SQL Server 2012 that return the first and last value from a list.
DENY vs REVOKE: Why a Removed Permission Still Works
You revoked a permission, but the user can still read the table. Here is why, and how DENY and REVOKE really differ.







