Posts by Brent Ozar

New Year’s Resolution: Lose Weight in Your Database

Indexing
14 Comments
Made a New Year’s resolution to lose weight this year? Forget taking it off your waistline – take it off your database instead with: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘size’ Or: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘rows’ This produces an inventory of all the indexes sorted by…
Read More

The SQL Server Posts You Read the Most in 2021

SQL Server
0
I think of my blog posts in a few different categories: Posts that will only be read at the moment they’re published (like upcoming webcasts, humorous stuff, and career advice) Posts that will show up in search history over time and continue to be evergreen (like how a feature works) Posts that provoke discussion and…
Read More
Office Hours - ask me anything.

[Video] Office Hours: SQL Server at Sunset

Videos
0
Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How to determine amount of memory (RAM) used by query store? 02:23 Aslan: Merhaba Brent, in your opinion, what are the top 4 databases to administer by DBA…
Read More

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Videos
4 Comments
Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…
Read More

[Video] Office Hours: First Post From Cabo

Videos
0
Join me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:48 md: Hi Brent, as SQL Server works with 8K pages why is the recommended NTFS Unit Allocation Size for SQL volumes 64K? Wouldn’t 8K be a more efficient fit? Sneaking in a second…
Read More
Office Hours Podcast

[Video] Office Hours: SQL Server 2008 R2 Edition, I Guess

Videos
0
I went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit of a 2008R2 theme! https://youtu.be/3-B5L3Komq4 Here’s what we covered: 00:00 Introductions 02:00 Pete Donnelly: Hi Brent, I have a 7 TB DB and the largest table is 2 TB, has 6 indexes and 6 related Statistics. It…
Read More

How Do You Test IOPs, Latency, and Throughput?

Storage
5 Comments
You’ve heard these terms thrown around about storage, and you’re not sure what they mean, and how they relate to each other. Let’s make it simpler by using an analogy. Say you want to measure a shipping company. You’re trying to decide whether to use DHL, FedEx, UPS, or your local postal service. You could…
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
Menu