/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

explainextended.com
| | kendralittle.com

Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.
4.3 parsecs

Travel
| |
| | sqlserverfast.com

I had to skip three months, but finally it is here: part eight of the plansplaining series. Each of these posts takes an execution plan with an interesting pattern, and details exactly how that plan works. I am pretty sure that (almost) everyone reading this blog knows that a CTE (Common Table Expression) is an...
5.5 parsecs

Travel
| |
| | matthewmcgiffen.com

Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
3.1 parsecs

Travel
| |
| | blobeater.blog

T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out on this one because I want to mention a connect item that I logged last year which is still active. This is an enhancement request for SQL Server where I got the idea from...
29.4 parsecs

Travel
|