Does my sample code not handle depths of 4?  I just tried it with a depth of 4 and it worked fine.

Do you have some sample data that is not...

I personally have not run into this - my upgrade from pre-2014 to post-2014 went 100% smooth for the ones that did migrate and the ones that we haven't migrated...

One thing I've learned from my years in IT and as a DBA and an application developer (I wear a lot of hats) - performance in SQL doesn't degrade unless...

You can, but it depends on what you are showing in the datasets.  There are some blogs about this, my quick search brought up this one which has good examples...

SSRS can only display and do calculations on data that is provided to it.  If you want the subtotal and totals, you will need that data pulled into SSRS.

There are...

Personally, what I would recommend is to use the OS that you and your team can support.

If you are responsible for managing the server and you have little to no...

My guess as to the slowness - you are doing things row by row and have a large data set to deal with and you are processing the data on...

My expectation - this is a non-issue.  Scripting tables across a linked server that changes database technologies is likely to produce weird results.  BUT if you want to blame someone...

Ok, so what is the web actually running against the SQL database?

If it is starting a SQL job (for example), the job may need tuning.

Since it is not SSIS, I...

How many non-clustered indexes do you have on the table?

The more indexes you have, the more stuff it needs to look at to delete.  If you can disable all of...

It depends on what the job is doing.  Since memory and CPU don't appear to be the bottleneck (their utilization is low), finding the bottleneck and improving on it would...

If you are going with Scott's approach, step 1 of the job would be to start the job you want to monitor.  Next, you wait for some period of time...

That one I am completely stumped on then.

Just to be sure, auto-shrink isn't turned on on any database, right?  My thoughts here are that something is growing and shrinking when...

Ok, that is a weird one... I have no good thoughts on why that would be happening nor why adding an explicit transaction would help.

When you say "randomly failing", is...

Could it be a bug in the unit test?  What I mean is if the unit test is checking the number of active transactions and sometimes it comes back with...