People seem to be missing the point here.  The simple fact is that it...

People seem to be missing the point here.  The simple fact is that it worked properly...

It's a two way street... It would have been nice if you'd done like Grant suggested.

It's frequently referred to...

Show your code, ol' friend, so that people don't just look at the...

Yep... I'm well aware of the default precision for DATETIME2 being 7.  That's the whole thing... I'm writing code to check for  proper  conversions from DATETIME2 (default of 7 for...

I cannot sufficiently nor politely express the growing level of disgust I've developed about Microsoft and SQL Server, especially since 2012 sp3.

I'd written some simple code to determine a difference...

Have you tried rebuilding statistics instead of indexes?

This is a nicely written article, Phil.  Thanks for taking the time to write it.

There are a few "gotcha's" because other people have published the same information for a very...

If you look at the column headers of the file and compare them to the table, they don't match.  We can't see your package to know what the...

Bumping the post so that the post above shows up on the next page.  This has been a long standing fault on this forum.  I sure hope the get around...

If you look at the column headers of the file and compare them to the table, they don't match.  We can't see your package to know what the mapping is. ...

To be honest, you're probably wasting your time doing traditional index maintenance.  Worse yet, you could actually be perpetuating fragmentation if you're using REORGANIZE.

With the thought that I named the...

If YOUR data center isn't "on the cloud", the On-Prem shouldn't be too different.  Normally, "on-prem" is another way of saying that the "data center" is not only owned by...

TBH... I'm deathly afraid of any changes or "improvements" that MS makes any more.  The huge slowdown that started with the new cardinality estimator in 2016 was the first big...