Thanks for reporting back with the solution. That'll help anyone who finds your question through searches.

TheSQLGuru (5/29/2015)

---

Grant Fritchey (5/28/2015)

---

TheSQLGuru (5/28/2015)

---

This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these...

Lynn Pettis (5/29/2015)

---

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how many people have to...

I can't honestly say the number of times I've seen this go badly. Views calling other views that are joined to views which contain other nested views... It feels so...

GilaMonster (5/29/2015)

---

DMVs don't store data, they're views into SQL's internal memory structures mostly, or database structures.

DBCC statements are very varied and...

In general practice, there's little distinction between Dynamic Management Views and Dynamic Management Functions. Most of the time they're all referred to as DMVs collectively. DBCC now means Database Console...

TheSQLGuru (5/28/2015)

---

This is SIGNIFICANTLY misguided, IMHO! I will jump through EXTRAORDINARY hoops these days to trade...

Well, you probably use some sort of standard for the file name I assume. Build that standard into your RESTORE statement. You'll probably have to use ad hoc T-SQL, but...

BL0B_EATER (5/28/2015)

---

I agree with Grant I have used Jonathan Kehayias's Extended Events script to get an idea of blocking, I just changed it slightly because I knew the database_ID that...

I actually got this right after thinking about it, but I think Hugo is accurate in what he's saying.

sys.dm_exec_requests will show you the immediately running queries that are experiencing blocking. You can combine that with sys.dm_exec_sql_text to get the query and sys.dm_exec_query_plan to get the execution plan.

There is...

Brandie Tarvin (5/28/2015)

---

Kyrilluk (5/28/2015)

---

In other words, the call to scientific method is good but is useless in certain aspects. It's good when everyone can reproduce the research (such as whether...

Another point, if you are trying to measure the execution time, make darned sure you turn off the STATISTICS IO when you do. They can radically skew[/url] the results of...

Never been, but it's on my bucket list. I really need to schedule one and get the company to pay for it.

One other point to consider is whether or not you're using local variables in the actual code or you're using parameters. If local variables, then you're seeing averages from the...