This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. I’m going to generalize a little by decade here to keep things simple. In 1990-2000, databases w … | Continue reading
BrentOzar.com is 20 years old, and I’m celebrating by being a little retrospective and future-looking this month. Today, I’m publishing a post that I could have published 10 years ago, or maybe 20 years ago, and maybe even 10 years from now. How much of this would have changed in … | Continue reading
This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. When I started working with databases, we had to: Provision the right CPUs and memory Provision … | Continue reading
We started out the How to Think Like the Engine series with a simple query with a WHERE clause: Now let’s add an ORDER BY: [crayon-5da126398b58a613775121/] Here’s the updated plan – note that the query cost has tripled to $17.72 Query Bucks. Let’s dig into why: We read the plan f … | Continue reading
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In the next several posts, you’ll learn: The differences between clustered and nonclustered inde … | Continue reading
At SQL Intersection in Orlando last week, a few of us were sitting around a table talking shop. One thing led to another, and as so often happens at conferences, we started talking about our worst scars from database misfortunes. That got me thinking – I could kinda bring that fu … | Continue reading
Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start. Query Design Tips 1. Code for readability first. The easier your query is for humans to unders … | Continue reading
Update March 19: Microsoft has since acknowledged a hidden limit, then documented it, then raised it – but it’s still disappointingly slow. In my last post, I explored how fast a $5,436/mo Azure SQL DB Hyperscale could load data. I’d had a client who was curious about spinning up … | Continue reading
I was working in my lab and I was having some odd blocking waits that I wasn’t expecting. I started firing up sp_WhoIsActive to see what queries were running, and I got a rather odd surprise: Ah-ha, the telemetry service, also known as SQLCEIP! Starting with SQL Server 2016, your … | Continue reading
This course is designed for junior SQL Server developers and app developers who want to take their T-SQL skills to the next level up, and have a little adventure in the process. We help you write efficient T-SQL code by covering thinking in sets, CASE expressions, computed column … | Continue reading
SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I’ve spent a lot of time writing Postgres queries lately. Here are some of the things I’ve noticed that are different. CTEs are optimization fences. In SQL Server, if you write this query: [crayon … | Continue reading