Posts by Brent Ozar

My Black Friday sale ends tomorrow.

Company News
0
The countdown timer is on: you’ve got less than 48 hours to grab one of my massively discounted bundles and get the SQL Server training you’ve always wanted at a price your manager can live with: Level 1: Fundamentals$395per year(save $1,390)Recorded Class Season Pass: FundamentalsSQL ConstantCare®Consultant ToolkitBuy NowLevel 2: Mastering$895per year (save $3,285)Recorded Class Season…
Read More

[Video] Office Hours on the Balcony Part 2

Videos
0
Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:22 Andrew from Canada: To Null or not to Null? That is the question. On tables with 100M to 1B rows and with several columns that contain data 20% of the time, should…
Read More

Free Live Class This Week: Fundamentals of TempDB

Company News
2 Comments
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind…
Read More

[Video] Office Hours on the Balcony Part 1

Videos
1 Comment
I hang out on my balcony in San Diego with a gin & tonic and a bunch of your highly upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:33 FishCakesForTea: I have designed a filtered index for a specific query but SQL Server doesn’t use it unless I move the columns in the…
Read More

Contest: SQL Server 2022 Needs a Slogan.

SQL Server
304 Comments
Now that Microsoft has announced that SQL Server 2022 is coming, it’s time for us to talk about a shameful truth: SQL Server doesn’t sell itself. Remember when everybody was talking about how MongoDB was Web Scale™? Or when Oracle was Unbreakable™? Even if you were making fun of it, the point was that you…
Read More

[Video] Office Hours Manhattan Edition: Ask Me Anything About SQL Server

Videos
0
I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Dylan: Do you have any experience with sys.dm_db_tuning_recommendations? To be clear, I am not referring to Azure SQL or Automatic Index Tuning, but rather Query Store Forcing/Unforcing plans automatically.…
Read More

[Video] Office Hours Speed Round: Quick Answers

Videos
1 Comment
Think fast! Not all of the questions at https://pollgab.com/room/brento have long-winded answers. In this 5-minute session, I crank through a bunch of straightforward questions: 00:00 Introductions 00:32 Mike: Hi Brent, the delete job is blocking for around 20 minutes our update or inserts calls from api which is expected to be completed with few seconds.…
Read More

What’s New in SQL Server 2022

SQL Server, SQL Server 2022
49 Comments
Today at Microsoft Ignite, Microsoft started dropping new details on the next version of SQL Server, 2022. Here’s a 13-minute video from Bob Ward explaining and demoing some of the new features: The new features include: Failover back/forth from SQL Server 2022 and Azure SQL DB Managed Instances, including restoring versionless databases from Azure SQL…
Read More
Mastering Query Tuning

5 Ways to Measure a Query

Execution Plans
2 Comments
In my free How to Think Like the Engine class, we start out by measuring query performance using logical reads. That’s the number of 8KB data pages that SQL Server has to read in order to find your query’s results. That’s the measure I use the most because generally speaking, the less data your server…
Read More
Menu