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...

Also don't forget that you don't just bottleneck on the disks. You also bottleneck on the disk controllers and the connections to the disks. I/O is a giant rats nest...

That's a big topic and not one that's going to be answered well within a forum post like this. I'd suggest starting out reading this article from the SQL CAT...

andrew gothard (5/28/2015)

---

meilenb (5/24/2015)

---

Everyone knows that CO2, CH4 and N2O are factors in climate change. CH4 (refrigerants) in particular is a 21 multiplier to CO2, R-508B (refrigerant) is a...

First question, did the execution time change with the removal of DISTINCT with the original indexing scheme?

Next question, did either of those indexes get used? Did you check the execution...

Kyrilluk (5/28/2015)

---

Grant Fritchey (5/27/2015)

Since I've seen many a DBA screw up a production environment, I don't see what makes developers special in either regard. However, exposure is an extremely well...

SQL Agent can call to T-SQL. You can use...

The execution time is the same? I'm not surprised the reads are the same. You're still scanning 45,000 rows.

There just isn't anything to tune in the query here.

Wild shot in...