That won't move existing LOBs.  You have to update each row to get...

Check to see if forced parameterization is on.  If it is, first take a baseline to see what performance is on the box then turn it off and check again. ...

We do nightly restores of two of our primary databases.

The large one is a 2TB database and has an 80GB log file with a compressed backup size of 500GB.

The smaller...

The key to my learning in SQL is that I learned very early on that one good test is worth a thousand expert opinions and taught myself how to make...

Not enough info to help here.  Are you sure that you created the file group on the correct disk drive?

What was the network issue???

Using the sample data that you've so nicely provided, can you post what the required output is?

Quick and simple. Converting a column from NVAR(MAX) to VAR(MAX) has drastically increased the data stored in the column.

Table size in MB is drastically higher after the conversion. There...

I find it interesting that this doesn't work when using the correct zero date for a datetime2:

DATEADD(dd,DATEDIFF(dd,'1900',DateValue),CONVERT(DATETIME2,TimeValue))         ...

None of those answers coming up on g0ogle are relevant to my question. They either talk about tracking down link servers which is not my issue, or they talk...

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