I can vouch for the settings that Johan mentions because those are the ones that changed my life for backups years ago.  However, I've found that they actually make restores...

Heh... Bing, Bard, BOOM!  I've done some simple but non-basic tests on both and they've both failed miserably.  Either the provide the wrong answer that wouldn't even run, produced the...

Hi Jeff,

I do not have force parameterization turned on. The sp passes two parameters as input. One is productcode varchar and locationid int. I checked the data and there...

Ha!

And we can keep going. Don't let Jeff get started on fragmentation. Don't let me get started...

Just to ask the question, the servers aren't set to automatically shut down for a part of the day, are they?

If not, you might want to make a call to...

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