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

Eric M Russell (5/27/2015)

---

Depending on the organization, I'm not opposed to allowing Developers read-only access to production, especially if they are expected to wear the Data Analyst hat on occasion....

Eric M Russell (5/27/2015)

---

Kyrilluk (5/27/2015)

---

Eric M Russell (5/26/2015)

---

Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the...

Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin password to the developers because of...

Since this is two completely different statements, assuming we're putting this into a stored procedure, why not create two stored procedures? You're looking at the need for two different execution...

If you can't get in with the DAC you may need to restart the service. Do it with the command lines -f and -m to get it to a minimal...

Views that call to other views and nest and join on views is a notorious code smell that leads to poor performance. My suggestion, write the query you want directly...

Sounds like there must have been some security changes on your server. The login you're using doesn't have permission to run the RESTORE command.

There's no way to correlate what's stored in those DMVs to any query. So, instead, you need to query directly against the XML of the execution plans in order to...