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...

I concur with the error found by Jeff Williams.  I also concur with the OUTER APPLY method being faster.  With the correct index, it's actually twice as fast as the...

Since the author of that article hasn't answered the latest question there in over 4 years, why not just try it and see?  Then, you can answer poor Jose's question...

To be sure, that's not "SQL Server".  There's no such thing as SQL Server 20.2.  What you're seeing is SQL Server Management Studio, which is also known as "SSMS".  That's...

Thank you for the feedback!

To follow up on Eddie Wuerch's good post, it's an old but powerful bit of ancient code known as a CROSSTAB.  You can get a good introduction to them in...