Last week's Visual Studio outage has been largely blamed on the cardinality estimator, but Aaron Bertrand says the query itself has a share of the blame.
Articles by Aaron Bertrand
Aaron Bertrand shows why and how you should upgrade your SSMS 2016 client from 13.0.11000.48 to 13.0.11000.78.
Aaron Bertrand describes a few different causes for a symptom you might describe as a "runaway" query in SQL Server.
We will be part of the SQLintersection event at the Walt Disney World Swan in Florida in April. Read on to see why you should be there too!
Aaron Bertrand discusses a few counterpoints to a very thorough and useful post on database naming standards.
Aaron Bertrand presents his first BackToBasics post of 2016, giving an introduction to common table expressions (CTEs).
Aaron Bertrand explains that cumulative updates are not to be feared and that the cautionary text accompanying them will soon be a thing of the past.
Aaron Bertrand shares a few of the queries he uses to quickly hone in on changes that have been implemented between SQL Server CTPs.
Aaron Bertrand provides a bit of commentary on the recent revelation of multiple harassment incidents that occurred at this year's PASS Summit in Seattle.
Aaron Bertrand explains how to get Plan Explorer to work with plans from the latest builds of Azure SQL DB and CTPs of SQL Server 2016.
Aaron Bertrand highlights three Connect items that will address some pretty important shortcomings in SQL Server statistics.
For this month's T-SQL Tuesday, @AaronBertrand treats some of the most memorable data modeling sins that he's seen over his career working with SQL Server.
Aaron Bertrand talks about new arguments to SERVERPROPERTY() that make @@VERSION even more obsolete (and changes that make @@VERSION problematic).
Aaron Bertrand explains how SQL Server 2016 improves tempdb configuration and performance.
Aaron Bertrand shares his PowerPoint deck and sample code from his most recent SQL Saturday appearance.
