Category: SQL Server

Aaron Bertrand reveals that the Books Online content for SQL Server 2014 is finally fully available, and shows two ways to perform installation.
Paul White uses several examples to describe subquery cardinality estimate bug.
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...
Continuing his series on knee-jerk reactions to wait statistics, Paul Randal (@PaulRandal) of SQLskil
Aaron Bertrand of SQL Sentry takes a look at some unexpected behavior with CASE expression.
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, 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.
August 17, 2012 | Jason Hall | Performance, SQL Server 7
The amount of misinformation out there on this topic is mind-boggling – IMO it's one of the most misrepresented aspects of SQL Server.
April 26, 2011 | Greg Gonzalez | SQL Server, Trace 0
There has been quite a bit of talk recently about a performance issue I see on Windows Server 2008 - the use of the default Power Plan setting of Balanced.
January 3, 2011 | Greg Gonzalez | SQL Server, CPU Performance 0
SentryOne founder, Greg Gonzalez, recaps the 2010 SQL Server Immersion event in Boston.
April 5, 2010 | Greg Gonzalez | Community, SQL Server 0

Top Categories

See all

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