Tag : SQL Server 2012 - SentryOne Team Blog

Tag: SQL Server 2012

Latest Builds of SQL Server 2012

Latest Builds of SQL Server 2012

SQL Server 2012 is now at its final build: Service Pack 4. See what you should know before deploying and find out what's been in each release over its lifetime.

A "drop column" fix you'll want for SQL Server 2012 / 2014

Aaron Bertrand (@AaronBertrand) cautions about using DROP COLUMN without immediately rebuilding the table. Wasted space is a concern; data loss is worse.

Paul White : Calculating the Median with a Dynamic Cursor

Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.

Aaron Bertrand : Pagination with OFFSET / FETCH : A better way

Aaron Bertrand (@AaronBertrand) shows how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.

Critical Fixes for 2012 & 2014 Online Index Rebuilds

Over on SQLPerformance.com, Aaron Bertrand (@AaronBertrand) warns about a parallelism bug in SQL Server 2012 and 2014 that could lead to data loss following online index rebuilds, and offers guidance on what to do depending on your current edition and build level.