We use Commvault pretty extensively. If you take backups of the databases using the SQL IDA in Commvault, then restores will actually be restores of the databases to an...

A little more detail on what happens here:

1) Creating and populating the table. Nothing special to see in this bit.

2) Running the SELECT * from the Query2 window. Also nothing...

Sure thing.

Here's a query that should find all the plans in the cache with parallel scans. I've modified the original query from here: https://www.sqlskills.com/blogs/jonathan/tuning-cost-threshold-for-parallelism-from-the-plan-cache/

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

WITH XMLNAMESPACES...

No problem, and thanks for the additional info!

The index was the reason I wasn't seeing the same results. Once I added that I saw the same results as you did.

In...

Thanks! Me, broken clocks, blind squirrels, etc. 🙂

It is a cumulative average, but it has a wrinkle that makes it more expensive to calculate.

For term 1, you average all the marks.

For subsequent terms, you average...

This should give the right results, but it strikes me as rather inelegant. Sometimes all I can find is a hammer 🙂

CREATE TABLE [gpa]([term] int,

...

Well, I can't say why with any certainty, but I know I've seen different results from enabling 1200 than I have from tracing Lock:Acquired and Lock:Released events, with the results...

Well, we can try to rule out the table variable estimate as a factor by trying the query using OPTION (RECOMPILE).

By forcing a recompile when the query executes, the...

Without knowing anything more than what we have here, my first guess would be that the estimates are way off. When it picks the plan that results in a 30...

There are quite a few differences. One of the best answers I've ever seen was a comprehensive look at that by Martin Smith over at Stack Overflow.

Check out the answer...

Heh, I like the wording. OP is "set" on doing it with the loop. Puns are great 🙂

I'm glad to have helped!

Also, be sure you're aware of exactly how BETWEEN works with datetime; if you're not careful it's easy to get the boundaries wrong.

My favorite write-up on...

This is a very common question, and no, there is no direct way to do this.

From https://msdn.microsoft.com/en-us/library/cc646012.aspx, the documentation on the debugger:

Expressions are Transact-SQL clauses that evaluate to a single,...