Tim Walker. (8/21/2015)

---

Eric M Russell (8/20/2015)

---

GilaMonster (8/20/2015)

---

The logical reads should be the same with identical plans....

GilaMonster (8/21/2015)

---

podmate (8/20/2015)

---

I have never worked for a tech employer that would pay you for training or encouraged you to train on company time (barring being sent offsite for training...

Eric M Russell (8/20/2015)

---

ZZartin (8/20/2015)

---

Eric M Russell (8/20/2015)

---

Jeff Moden (8/20/2015)

---

Iwas Bornready (8/20/2015)

---

I just worry about the programmers that want to "fix" something that isn't broken, just to make it more...

Ben Whyall (8/20/2015)

---

Thanks for all the help so far, this is a production backup that I have had to bring down onto my machine to look at this specific problem....

GilaMonster (8/20/2015)

---

The logical reads should be the same with identical plans. The physical reads may not....

ZZartin (8/20/2015)

---

Eric M Russell (8/20/2015)

---

Jeff Moden (8/20/2015)

---

Iwas Bornready (8/20/2015)

---

I just worry about the programmers that want to "fix" something that isn't broken, just to make it more efficient. As often...

Jeff Moden (8/20/2015)

---

Iwas Bornready (8/20/2015)

---

I just worry about the programmers that want to "fix" something that isn't broken, just to make it more efficient. As often as not they really...

Are you looking at logical or physical read counts? The two combined should sum near the same with two identical plans, but balance between them may differ depending on how...

To optimizes the performance of queries against large tables, SQL Server utilizes a data page cache and read-ahead buffering to reduce physical reads (disk) and maximize logical reads (cache). This...

Luis Cazares (8/20/2015)

---

Well, considering that it has been 6 years now since...

For users who have a habbit of dropping databases, I've found the following works too.

ALTER SERVER ROLE [sysadmin] DROP MEMBER [username];

And, if they know the password for 'SA' account, then...

I guess the real questions at this point is not "how to I recover a dropped database?" but rather "how do I recover a deleted file?".

How Volume Shadow...

I guess the real questions at this point is not "how to I recover a dropped database?" but rather "how do I recover a deleted file?".

How Volume Shadow...

Programmers have it a lot easier than doctors. We have the luxery of practicing on test subjects, before moving on to the real thing, and even when we get stuck...

Eric M Russell (8/19/2015)

---

OUTER APPLY (

SELECT...