The one thing you can do, that Gail was leaning towards, would be to have a table on a filegroup. You can restore a filegroup individually.but, the issue here is...

Steve Jones - SSC Editor (5/6/2011)

---

Interesting blog post from Roy. Anyone ever tried this?

http://www.sqlservercentral.com/blogs/dba_rumblings/archive/2011/05/06/why-you-should-ask-your-cto-to-attend-the-user-group-meetings.aspx

I used to go to a networking conference with my boss. A bit of a boondoggle, but...

Sounds like you're not...

There is no criterial for a join between those tables. It looks like you want a LEFT JOIN, but without joining criteria (a foreign key), you can't make that happen.

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

Yes.

There is no "in general." It really depends on the situation and you should test your situation because different ones will work better under certain circumstances.

Without using a 3rd party tool, nope. You have to restore the database somewhere and then retrieve the tables that way.

If you want to talk about possible 3rd party solutions,...

It could be blocking, other processes running on the server causing the restore to slow down. Or, it could be that open transactions on your backup are being rolled forward...

You should not be shrinking your files as a regular part of your operations. If you are, that's indication of problems somewhere. It does sound like you're in Full Recovery,...

I'd look to see if there are blocks of some sort going on in production, but other than that, I'd want to see more data gathered. You said the servers...

I go with PowerShell and use remoting and then you can thread it and fire it on every server, all at the same time, no issues. Here's a small blog...

There is no alternative tool. That's the best one.

You will absolutely need to plan for thorough testing. One of the issues we found early on when migrating to 2005, but...

yes, the problems do occur in the engine, but they're very rare. If you're hitting them all over the place, then I'd suggest one of two things is true. You...

Nuts. I'm slow. Yes, the Upgrade Advisor is the best source for this information. It's the required first step to perform this kind of upgrade anyway. Follow Microsoft's documentation. It's...

It's possible you've hit a regression, a piece of code that worked well in 2000 but not so well in 2008. Usually this happens on code that is problematic to...