Search Results for “index fragmentation”

  1. Home
  2. Search Results
  3. (Page 3)

5 Things About Fillfactor

Index Maintenance
Are you a page half full, or a page half empty kind of person? I’ll never think “I’ve seen it all” when it comes to SQL Server– there’s just always someone waiting around the corner who’s found a weird new thing to do with it. But there are some things I really wish I could…
Read More

Potential Problems with Partitioning

Partitioning, SQL Server
Getting started with table partitioning is difficult; there are many decisions to make after you’ve decided to partition data. Correctly configuring partitioning is critical to the long term performance and stability of the database from both a querying and data modification standpoint. There are three key considerations that database architects should devote time to before…
Read More

Wordle for

Michelle Ufford of SQLFool tagged me in her latest post, asking me to produce a Wordle map of  You go to, put in your blog URL, and they produce this beautiful map of your most commonly used words from your RSS feed. Wordle Map of Faithful readers of my blog will recall…
Read More

SQL Server 2005/2008/2012/2014 Setup Checklist

SQL Server
Ever wonder if you’re missing a step when you set up your SQL Server? Get a checklist to install and configure your SQL Server the right way! We’ve built an easy-to-follow SQL Server Setup Guide for systems administrators, DBAs, and developers that helps you prevent the most common issues we see out in the field. The guide…
Read More

New Year’s Resolution: Lose Weight in Your Database

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

[Video] Office Hours at the Seltjarnarnes Lighthouse

You posted and upvoted SQL Server questions at, and I went out for a walk on the Seltjarnarnes peninsula to the lighthouse to answer ’em. Here’s what we covered: 00:00 Introductions 00:58 Gio: Any known gotchas from using Windows Update to apply CUs to SQL 02:17 AlwaysLearningDBA: Hello Brent. A friend of mine wanted…
Read More

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

1 Comment
You’ve got questions, I’ve got answers. Welcome to another edition of Office Hours, where you post your questions here, upvote the ones you’d like to see me talk through, and I do your bidding: Questions we covered this week: 00:00 Introductions 01:30 Are DBAs transitioning to other roles, and why? 04:48 Why is it hard…
Read More
Fundamentals of Columnstore Indexes

04 How Columnstore Data is Rebuilt

Now you’re starting to see the challenge of maintaining query performance. The combination of these three facts: Columnstore indexes are like lots of partitioned column-level indexes, and Newly changed data ends up in separate rowstore indexes called delta stores that just get scanned, and they don’t have any of their own columnstore indexes, and Selects…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
Read More

Can deleting rows make a table…bigger?

Michael J. Swart posted an interesting question: he had a large table with 7.5 billion rows and 5 indexes. When he deleted 10 million rows, he noticed that the indexes were getting larger, not smaller. Here’s one way that deletes can cause a table to grow: The rows were originally written when the database didn’t…
Read More
Brent Ozar's Consultant Toolkit

Consultant Toolkit

0 customer reviews
You’re a consultant, and you need to get diagnostic data from your clients’ SQL Servers. You’re tired of asking them, “What version are you running?” and “How big are your databases?” You’re sick of running DMV queries one at a time, copy/pasting the results into files. You’ve played around with the built-in tools like PSSdiag,…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/10 (With Transcriptions)

This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is currently teaching at the client location, SQL Server in containers, heap index maintenance, contained databases, extended events, the difference between a junior and Senior DBA, page file sizing, and more. Here’s the video on YouTube:…
Read More

What’s New in SQL Server 2019: Adaptive Memory Grants

When you run a query, SQL Server guesses how much memory you’re going to need for things like sorts and joins. As your query starts, it gets an allocation of workspace memory, then starts work. Sometimes SQL Server underestimates the work you’re about to do, and doesn’t grant you enough memory. Say you’re working with…
Read More
SQL Server Internals 201 Training Class

SQL Server Internals 201

1 customer review
You’re a developer or database administrator, and you’re curious. You love learning about the internals of the tools you use. You’re comfortable writing queries and creating tables, but you don’t always understand why a particular index gets used, and another one does not. You’re not sure when SQL Server chooses to reuse an existing query…
Read More

Practical Real World Performance Tuning

39 customer reviews
In the real world when we face any performance problems, we do not have the luxury to open PowerPoint and study theory. What helps us during the time of crisis are handy scripts which help us fix our performance problems. In this quick paced, demonstration oriented learning workshop, we will see how we can immediately…
Read More