Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes...

Given that the data type is DATETIME2(7), we can assert the following: The DATE data type is 3 Bytes big-endian, the TIME(7) is 6 Bytes big-endian and...

We use the following providers for linked servers and use OPENQUERY, which proved much faster than OPENROWSET (with the disclaimer that check was made years ago).  This allows the query...

• This reply was modified 2 years, 6 months ago by Jeff Moden. Reason: just realized you specified "No Linked Server" in your post

@Eirikur,

The "Human Factor" is why I value QA Testers so much (and, MAN!  They taught me how to anticipate user actions, also known politely as "Human Factors").  In this case,...

Thanks, Jeff for this very good writeup (as always)! 😎

Just a quick point, DATETIME2 is defaulted to DATETIME2(7), not considered the same data type as DATETIME2(<>7), same goes with...

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, 7 months ago by Jeff Moden. Reason: Add conclusion for addition testing done
• This reply was modified 2 years, 7 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,...