Loading a heap and indexing it afterward only moves the work. Time the whole pipeline before you pick a winner.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.