It's all based on the estimated costs of the query as determined by the optimizer. If that estimate is higher than the cost threshold for parallelism, then you have the...

Yep, that's it. It's a DMV to give you a view into what things are waiting for what in the server. You'll need to look in BOL or online at...

There's still not enough information to see exactly what the cause of slow performance might be. I'd suggest you gather data using sys.dm_os_wait_stats. Get that information together over a period...

sp_executesql is actually one of the best ways to run ad hoc tsql because you can parameterize it and get more plan reuse.

It sounds like, possibly, you're hitting a parameter...

It's possible that it's a memory issue. What other metrics have you gathered? Do you have wait statistics available? That will tell you what things are waiting on, which is...

What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?

Yeah, it was absolutely top notch. Too bad he didn't write it for the Standard. I would have paid more. 😀

Don't get hung on OLTP = no paralellism. I've seen it go both ways. I agree with George (stop banging your head). Most of the time the cost setting is...

I may as well pile on here since we clearly don't have a consensus.

Either will work.

Either will work with multiple servers, multiple databases, etc.

However, PowerShell offers much more flexibility and...

It's possible. All those ISNULL functions on your columns are going to absolutely kill performance. Have you looked at the execution plan for the query, both on the fast servers...

I agree, the best skill you can begin to develop immediately is the ability to do a search. Remember, you're not the first person down this path. Actually, it's not...

Excellent article. You made several points and made them well, not the least illustrating why "it depends" is such a common statement.

Well done Lynn