http://msdn.microsoft.com/en-US/library/ms187762%28v=SQL.90%29.aspx

http://msdn.microsoft.com/en-US/library/ms174283%28v=SQL.90%29.aspx

You can partition out tables to gain some performance, but if this is just a management issue, I would say that you might want to move some tables (moving their...

Please do not post homework/exam/interview questions with the expectation that someone will do them for you. You are responsible for doing your own work. Or your friend is.

We are happy...

I'll add another note to say if you aren't using the BI features, I'm not sure there's value in upgrading to R2

Good for you, Roy, and glad you had a good time. Good to see you back online.

Sore

Michael,

That's a good idea. I might built such a DDL script that people can use to do their own counts and analysis.

Excellent article, and definitely I learned a few things from this one.

It's a good thing SQL Server does a pretty good job of limping along on its own with DBAs like that.

This was an April Fools Joke. It says so in the explanation as well as in the thread linked.

No need to get too worked up about it.

Please don't curse in the forums. It's unprofessional in this environment.

You configure this in the server properties http://msdn.microsoft.com/en-us/library/ms188470%28SQL.90%29.aspx

baseball

George is correct. Also, the log backups will not reuse the space until the transaction commits.

You might want to break it into batches if you are worried about log growth.

We do not condone posting of PDFs that are for sale. If you want to learn about SQL Server, make your own investment in a book.

Or use the free...