Same...

(1) What is the 'cost threshold for parallelism' on that instance?  If it's too low, SQL could be trying use parallelism far too often.

(2) Check the SQL log for error-type...

Restore the qa to prod under a different db name.

Once you verify that the restored db is what you want, then:

DROP the original db;

RENAME the restored db to be the...

I'd jury-rig this one: replace the 3 chars with a single char, then use the "standard" splitter:

;WITH test_data AS (
    SELECT ' a=abc;&;b=1;&;c=ddd' AS...

It was not "obvious" that you were speaking of VARCHAR because they are NOT affected by row compression at all.  Only CHAR is affected by row compression and you...

• This reply was modified 3 years, 4 months ago by ScottPletcher.

When you read this, Scott, remember that I LOVE page compression...

You say the following but you need to qualify, especially to a person who might not know what compression...

It doesn't take much to cause a page split with compression enable on tables that aren't suffering from page splits to being with.  If you're going to use compression...

It depends.  Unfortunately SQL can only trap certain errors; for some errors, even a CATCH won't "catch" an error.

For example, if you use and invalid column name -- one that...

Just as a bit of a sidebar, remember that page compression causes CI rebuilds to take about 3 times longer.  I'm NOT saying that makes it not worth it...

Are you page-compressing that table?  If not, why not??  Especially since it is read-only almost all the time.

Actually, if you have LOB off-page data, that data will not be moved simply by CREATEing the clustered index on another filegroup.

Does that take care of the whole "season" of dates the OP identified

I need to create a query where  the first of March will be  Week 1...

No need to overly complicate this.  Just calc the starting Monday date, then determine week# displaced off that "base" date.

I moved the time adjustment into a CROSS APPLY only so...

Either method will work.

Personally I prefer using the TimeTaken column.  Triggers with transactions can be used to ensure that the times are kept in sync.  Of course you'd want a...

No.  For an explicit transaction, you need an explicit COMMIT or ROLLBACK.