Glad you found the answer. I always go back to Microsoft for licensing questions. They're going to be the ones to enforce it, so you might as well find out...

Absolutely. Just go here to sign up for a free trial[/url]. If you have an MSDN license, you have up to $150 in credit you can play with in Azure.

Or upgrade to 2014.

According to MS, that column was added with 2012, so all you can do is left joins to the sys.dm_exec_requests.

Although, you might take a look at Adam...

If it's a one time thing, shrink it. One, two or three shrinks over the life of a database is no big deal. It's the people scheduling monthly, weekly, daily...

The good news is, you have full optimization, so the optimizer didn't time out leaving you with a junk plan. The bad news is, yikes.

I suspect you may have some...

Either google-fu is failing me or I'm delusional about the recording of the discussion (both possible). Sorry.

No, i'm sorry Stefan, I don't have a specific resource on that one. It's something that came out of multiple talks with Oracle people to get an understanding of what...

To a degree, what people think of as cursors in Oracle (and maybe in other DBMS, I'm not sure) are two things, one of which we have in SQL Server....

Assuming TableA is the parent to TableB and that's the parent to TableC, then your delete order should be:

TableC

TAbleB

TableA

If you try anything else, you'll get referential constraint errors, as it...

Data can be cached on the servers outside SQL Server, then the queries against SQL Server won't ever show that data. But that's the only thing I can think of...

Then where are...

You can get some idea of what's accessing it by querying sys.dm_exec_query_stats and combining that with sys.dm_exec_sql_text and looking for your particular table. But, that's only going to show the...

And don't use the Profiler gui against a production server. It can add to your problems because it buffers data in a different way than server-side trace.

Sure, the duration in SSMS includes the time it takes to move the query and the results across the network. Trace and extended events just measure the time it takes...

Yes, it...