Search Results for &#8220;index fragmentation&#8221;

Index Maintenance, Ola Hallengren's Database Maintenance Scripts

128

If you’re a production database administrator responsible for backups, corruption checking, and index maintenance on SQL Server, try Ola Hallengren’s free database maintenance scripts. They’re better than yours (trust me), and they give you more flexibility than built-in maintenance plans. However, the index maintenance defaults aren’t good for everyone. Here’s how they ship: Transact-SQL CREATE PROCEDURE…

Rebuild or Reorganize: SQL Server Index Maintenance

Last Updated February 13, 2017

Kendra Little

Index Maintenance, SQL Server

109

Index maintenance compacts a structure *and* changes physical order– both can be important! Editors Note: this post was updated in June 2014 to link to an online index rebuild bug that can cause corruption. Once up on a time, there was a database server with 500GB of data and a heavy read workload of dynamic…

Self Loathing Indexes

Last Updated July 27, 2020

Kendra Little

Diagnosis: Self-Loathing Index Disorder. Your indexes may seem like they’re not quite living up to their potential– because they probably aren’t. Our data says that your indexes may need your help to fully respect themselves again. Low Fill Factor We looks for any index where the fill factor is 80% or less. Fill factor is…

sp_BlitzIndex®

Last Updated February 6, 2024

Brent Ozar Unlimited Team

sp_BlitzIndex® – SQL Server’s Index Sanity Test Your SQL Server indexes may be less sane than you think. Download sp_BlitzIndex® to find out– or scroll on down and watch a video to see how it help you find out: Do you have duplicate indexes wasting your storage and memory? Would you like help to find unused…

Stop Worrying About SQL Server Fragmentation

Last Updated March 5, 2017

Index Maintenance, SQL Server

138

I bet you’re worried about your index fragmentation. If your database was a phone book, it would look like this one. And I bet you’re wasting your time, missing the real point. What is Index Fragmentation and How It Happens Let’s take a step back for a second and pretend that your database is a…

Indexing for Deletes

Last Updated February 13, 2017

Jeremiah Peschka

Indexing, SQL Server

If you’re only indexing to make reads faster, you need to think again. Indexes can make every operation in the database faster, even deletes. The Problem: Deletes are Very Slow I was lazily researching new development techniques one day when I received an email from a client asking why deletes could be slow. I rattled…

[Video] Office Hours: Sunshine Edition

Last Updated December 12, 2023

You know how this works: you posta the questions at https://pollgab.com/room/brento, and I giva the answers: Here’s what you asked in this episode: 00:00 Start 03:18 DBA in VA: I recently discovered the “force order” query hint. I’m usually inclined to let the optimizer do its thing, but I have seen some of our code…

[Video] Office Hours in Camden Harbor

Last Updated October 25, 2023

On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:54 Alma Fahlstrøm: Does index fragmentation matter with column store indexes on SQL 2019 / NVME San storage? 01:22 Miss Minutes: What is your recommended way to find the…

Office Hours, Silent Film Edition

Last Updated November 11, 2023

Hey, remember in yesterday’s video how I said I was having a really bad day? Well, here’s how bad it was – I recorded two videos in a row, and I forgot to turn my microphone on for the second video. <sigh> So here are the questions & answers: 00:25 Calvin H: Any tips or…

It’s Friday. I’m Not Answering These 14 Office Hours Questions.

Last Updated June 21, 2023

Sometimes, I don’t care if questions get a lot of upvotes at https://pollgab.com/room/brento – I just don’t wanna answer ’em. They’re not necessarily bad questions, but I’m just not interested in them, or I’ve answered them repeatedly, or I don’t have a good answer. Maybe y’all do, though, so I’ve numbered these. If you want…

[Video] Office Hours: Azure & SQL Server Q&A

Last Updated May 4, 2023

Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams. Here’s what we covered today: 00:00 Start 01:56 Manoj: Where do you see artificial intelligence having the most impact on DBA’s? 03:25 It’s ‘a me: Hi Brent, is it still “best practice” to have databases split into…

Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions

Last Updated January 31, 2023

In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all posted at http://pollgab.com/room/brento/. Brilliant! Let’s see how it does. I purposely cherry-picked the questions that I thought ChatGPT would have the easiest time answering. Rollback is single threaded asks: Hi Brent! An update statement has blocked all…

[Video] Office Hours: Ten Minutes of SQL Server Answers

Last Updated January 16, 2023

ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 01:13 Timbalero: Hi Brent. my friend knows your view on rebuilding indexes. He also thinks that external index fragmentation affects pretty much only readahead scans. For scientific purposes, what metrics…

Office Hours Speed Round, Text Edition

Last Updated August 10, 2022

Got questions for me? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. I filter out the ones that are too short for video answers, and here’s the latest batch: Corrupted: Should DBCC CheckDB be run on secondary replicas in AG as well ? Is it recommended to attach corrupted…

Office Hours Speed Round: Text Edition

Last Updated July 13, 2022

Not all of the questions you post at https://pollgab.com/room/brento are hard. Some of ’em can be answered in one line: Q: accidentalDBA: Hi Brent, My friend is moving from two physical servers (production + failover) to VMs on the same host and SAN. His manager wants to keep log shipping as a DR solution. I…

DBA Training Plan 14: POP QUIZ!

Last Updated August 28, 2019