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

One more thing. If there are any domain groups (like MyCorp\DBA) or local Windows server accounts (like BUILTIN\Administrators) that are members of SYSADMIN database server role, then confirm that this...

hurricaneDBA (8/20/2015)

---

Thanks for the reply everyone. The contractor requested to have db owner privs hence was the reason I asked about hiding the security folder. When I tried it with...

jckfla (8/19/2015)

---

Eric M Russell (8/19/2015)

---

So, I'm guessing SOX regulators required them to have an alternate business continuity process on standby. In...