Mike,

good points, although often we have the plans cached, so I'd expect that if I run a query regularly, I'm getting the same plan every time.

Perhaps this isn't a great...

Ultimately you need to test and get an idea of when it's quicker which way. It often does depend on how much data, and your disk I/O.

Please start a new thread and explain your issue better.

If you are doing a bare metal restore with some software, where are the MDF/LDF files? The bare metal restores I've seen (and they rarely work, in my experience), include...

My apologies for the plagiarism. I have removed the article, and reported the author to OSI Consulting[/url], the employer whose email server was used to send the article in.

Restore syntax: http://msdn.microsoft.com/en-us/library/ms186858%28v=SQL.100%29.aspx

There isn't a good example there, but basically

restore database xxxx from disk = 'yyyyy' with norecovery

restore log xxxxx from disk = 'zzzzz' with norecovery

restore log xxxxx from disk...

John is correct. you need to restore/move, all the files that are returned from the RESTORE FILELISTONLY command.

Added my vote. That's a good suggestion, though I wonder how well people would know how to use it.

LOL, I assumed it was a typo.

There's a start here: http://sqlblog.com/blogs/arnie_rowland/archive/2010/08/31/project-phoenix-late-august-awards-announced.aspx

I think it would be great to have people helping out, though I wonder how it would work for these projects, which are often long term...

There's a discussion for each question. If you check that, you might see if someone else saw a similar issue.

Which question is this? Can you provide a URL?

If he responds, please ping me. I'll send a note back through PM.

I use both products. I have my OneNote folders (they're just windows folders and documents, synced on Live Mesh, so they move across multiple machines for me. This allows me...

Alvin Ramard (9/10/2010)

Steve, you should try Peggle. ...