To be honest, I've found that most such contention is because of what is appropriately referred to as "crap code". 😉

I recommend that you figure out what's beating on TempDB...

Post the CREATE TABLE statement for the table the index is a part of including the CREATE statements for the index(es) in quesiton.  Then, post the results of a...

Ok then,  this will be short.

The code says it ignores UNIQUE indexes.  Your spreadsheet says...

Hi All,

We have a 2 TB disk to stored of the sql database files. db has 3 data files and 1 log file. log file is stored on a...

Hey there, Sam...

I took a look at your index spreadsheet.  That's a good thing but it's missing some critical information...

1. Add an IsUnique column to identify if the index is...

There is some original basis of truth in rumor and old wives tales.  While you place no faith in Fox, it did make people at least look.

While your opinion that...

Ah... I found the word I was looking for...

Lookup the term "enshittification".  It's a term that was coined by XXXXXXXXXX in 2022 and became the "word of the year" for...

Understood.  Thanks for the feedback, Steve.

As an important sidebar, I don't know why you need to do this but it's generally a really bad idea to denormalize data in such a fashion.  Maybe post the...

Hi All ,

fitst you need to disable all maintenance plan   , perhaps your rebound or organise process all table without considering fragmentation .

also tha sal server audit can...

change the database compatibility to SQL2019 prior to the items below.

the optimizer is different between versions, so it's pretty standard to have to, at a minimum, rebuild statistics with...

I second that question.

@Grant Fritchey,

I think you'll absolutely love the following article...

https://getpocket.com/explore/item/looking-to-ditch-twitter-morse-code-is-back

Is someone doing any form of Index Maintenance?  It may not be in a separate job somewhere.... it may be something that someone has added to a stored procedure because...

If you can send a note to marketing@ with your specific complaints or issues, that will help. There is a proposal up with our internal IT staff/developers to do...