Category: 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.
Paul White demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: median with a dynamic cursor.
Aaron Bertrand shows how to use common table expressions...
January 12, 2015 | SQLPerformance.com | T-SQL, SQL Server 2012 0
Over on SQLPerformance.com, Aaron Bertrand 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.

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial