And I found another great question today. Someone hadn't had an answer in a few days, so they edited and removed their question.

Grrrrrrrreeeeeaaaaaaattttttttttt

Most sources we use are paid for. There isn't a lot in the public domain. Posting a short excerpt from a book is no different than from a website. You...

The compatibility level has nothing to do with the structure of the file, or the way the backup is taken. It only determines how the 2005 engine interprets the code.

Once...

nope, you cannot restore downlevel.

Script out the schema, run on 2000. Use SSIS or the export wizard to move the data.

Barry, sourced, quoted, limited to < 1 para, fair use.

Run the upgrade advisor to see what pops up.

I would also run a profiler trace of a test upgrade and look for deprecated code. There's an event for that....

$25 from Amazon will cover this: http://www.amazon.com/Omaha-Steaks-Boneless-Pork-Chops/dp/B0017129DC/ref=sr_1_2?ie=UTF8&s=gourmet-food&qid=1266945895&sr=8-2

Sure you can run that query, but will you run it for every table adn every day? Or are you going to assume the growth that occurs today is representative?...

The solution or the contest? You can post on your blog later, enter the contest now.

Since this became a performance discussion, I added a question on ASK about the best method. I know someone might memorize this for an interview, but you could easily change...

12,000 posts, amazing. This is like the longest Cheers episode ever.

Lowell has what I'd suggest. Make sure the service account and see the share.

sqlguy-549681 (2/23/2010)

---

Hello Steve,,

as you said "The formulas for calculating space are trivial. It's the information gathering that is hard."

would you please tell what are the informations I must...

Two issues with snapshots - They require Enterprise Edition and you still have the connection issues. If I build a snapshot every 10 minutes and I have a report that...

Rebuilding the clustered index will do this as well. Not sure if it's quicker than making a copy of the table and renaming, but you essentially need to move all...