If databases that are no longer on the server are in the backup history, that just means the history wasn't cleared when the database was dropped. You can use sp_delete_backup_history...

Piling on, but same thing, you won't know for sure how much compression you get for sure unless you use it.

Lowell (6/7/2011)

---

thanks for the clarification Gail!

you said "... If a plan is never cached, it won't appear in the query stats DMV at all...", can you clarify?

I thought every...

WayneS (6/6/2011)

---

Jim,

If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it... he can fill you in on...

I'll be making a new avatar out of a scary/goofy picture of me in a wet suit up in Alaska right before we went snorkeling... on the other hand, it...

Congratulations Grand Dad!

I'm a surrogate key fan too. I do tend to treat them like natural keys on the child tables. I was taught a mechanism where the master tables are are...

You're right, this can be practically a religious war.

In general, I've found that identity works well, but can be abused. In the situation you're describing for example, I'd go with...

WayneS (5/28/2011)

---

Grant Fritchey (5/28/2011)

---

WayneS (5/28/2011)

---

Jim Murphy (5/27/2011)

---

<giggle>. This is probably Grant's biggest fear for the precon. Especially since Jen says that "book authors don't know anything" at SQLRally. For clarification,...

WayneS (5/28/2011)

---

Jim Murphy (5/27/2011)

---

<giggle>. This is probably Grant's biggest fear for the precon. Especially since Jen says that "book authors don't know anything" at SQLRally. For clarification, (inside joke) Jen...

And to you!

First time in years I won't be marching in the parades in town with the Scouts. Stupid Alaska cruise.

Sounds like you set it up to log in as 'sa' and you don't have the password correctly entered. You may need to try the install again. Pay attention to...

If you're moving up to 10TB systems and you haven't handled that level before, I'd strongly recommend getting some consulting help in on your project. Anything past 1-2TB requires specialized...

Piling on for just a moment, but you need to know this, all those functions running in your columns is going to prevent any indexes on those tables from being...

I'd guess either differences in data or statistics being out of date on one of the servers. Hard to say without seeing the execution plans.