Here is a little ditty I coded up yesterday to return a quick and dirty difference comparison between two tables having identical column definition and overlapping rowsets. It's new, but...

We already have the SSMS Template Browser to cover commonly used commands and DMV queries.

However, the MERGE statement is complicated enough that it could use a GUI helper, if that...

An hour long pre-recorded video covering generic IT security topics, something the employees watch alone from their desk during a lunch break, probably doesn't count for much, if they've seen...

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