Category: SQL Server

This month's T-SQL Tuesday deals with SQL Server assumptions, and there is certainly no shortage of those to talk about. In this post, Aaron Bertrand lays out his five favorite assumptions people make about SQL Server.
Paul White continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential...
Aaron Bertrand of SQL Sentry takes a look at some unexpected behavior with CASE expression.
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.
Lori Edwards discusses an issue where, when giving a demo, she discovered that a newer version of SQL Server was missing a fix from an earlier service pack.
March 31, 2014 | Lori Edwards | SQL Server, DMFs, DMVs, service packs 0
Jason Hall walks through the five most common SQL Server performance problems he comes across while providing support for SQL Sentry customers.

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