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.
SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012
An introduction to CUME_DIST, a new analytic function in SQL Server 2012 that returns the cumulative distribution of a value, with an example.
Checking Data Compression Settings on Every Table and Index
A table is not simply compressed or not. Here is how to read the setting for each index and partition, and the mistake that leaves indexes full size.
SQL SERVER – Updating Data in A Columnstore Index
A reader got an error when updating data in a columnstore index table. Here is why the table becomes read-only and what you can do about it.
Splitting Work Into Equal-Sized Batches With NTILE
NTILE deals 100 customers into eight batches in one query. The catch is keeping those batches stable while new rows arrive.