Thanks for the interesting post!

Could you explain the why varbinary is used for the time but binary is used for the date?  I tried using binary for both (albeit...

• This reply was modified 2 years, 5 months ago by Jeff Moden. Reason: Add conclusion for addition testing done
• This reply was modified 2 years, 5 months ago by Jeff Moden. Reason: Added note about why DATE wasn't converted using a VARBINARY()

My other feeling was that having it run multiple times (2, 3, 4?) at the start of the month could be deceptive / confusing to people looking...

My other feeling was that having it run multiple times (2, 3, 4?) at the start of the month could be deceptive / confusing to people looking at the...

I agree.. small changes in knowledge are easier to learn and remember than trying to learn everything at once.  I've also learned that, instead of learning how to solve a...

I Googled the following...

What is the best way to track down what users\logins are accessing my linked servers in sql server?

It came up with a lot of answers.  Just for...

I think all of this cloud stuff is a bit odd.  It's actually very old thinking.  Remember when people thought you were stupid if you didn't "decentralize" so that you...

SCDs (specifically, type 6 Slowly Changing Dimensions) would work the best.  One of the better SCD methods is System Versioned Temp Tables.

https://en.wikipedia.org/wiki/Slowly_changing_dimension

I would avoid the use of a simple "IsCurrent"...

Just posting so Michael's post above will show up.  This site won't show a single post on page 2.  I really wish they'd fix that. 🙁

After reading this, I had this vision of the very old "graphic" of a snake eating its own tail.

I hate rebrands/renames. I think it creates confusion and often doesn't make anything better. Either you execute well or you do not and people know that, regardless of name.

However,...

Good morning,

I am able to rebuild this index. And thats the problem, when I could rebuild the index, why wouldn't the Ola script rebuild the index?

I thinks, this is...

That was going to be my guess and for the same reason.

@ Andreas,

How are you verifying the fragmentation on that table after you've executed the OLA script?

Also, Michael's question is valid... your answer might be "to defragment the bloody index!" but...

I don't see where anyone has already said it, so I'll say it… “MMYYYY” is a date format to avoid. Using “YYYYMM” instead will allow you to actually sort...

Understood.  For me, performance is 2nd only to a correct result... and its a very, very close second and...