I agree with Sugesh. It's not necessary, but it can help. The important thing is to really balance the pros and cons of the .NET v TSQL and choose ...

I avoid new instances because of the memory limitations of most machines. It might be better to let SQL Server manage the memory and CPU. In SS2K8, there will be...

I appreciate everyone's responses and one of the great things about this is being able to express disparate opinions. However, there is a time and place where free speech applies.

If...

I updated Carstens after an email. If you have issues, please send them to sjones at sqlservercentral.com (60x60 pixels) and I'll upload them. Include your registration email.

Yikes, hate to hear that. I worked on the 443 and 444 exam book for Sybex.

In SQL Server 2005, there's the MCTS and MCITPro certs. Use SQL Server 2005 and...

Good advice above.

I'll add that you should document your work and use email to respond to people when there are issues, copying your boss. If he cannot work with you...

Hugo,

No offense and you brought up some great points, but honestly when I'm working on questions, I work in one area, try to write 3-5 questions on something in that...

http://www.sqlservercentral.com/columnists/sjones/3044.asp

Got a second part coming as well.

You ALWAYS want free space in your data files. This is so as you add data, it has a place to go. The only time you'd want 0% free space...

If I understand, you want to create a new log file and then remove the old one from your database? AFAIK this isn't possible. You can "move" the log to...

I don't live in Iowa and I use Google too. I've been disappointed in Live, though the MS folks at TechEd claim it's much better.

I'm sure Google made the decision...

Wow, you guys are overthinking this. The questions aren't intended to cover every possible option on your server. It's intended to help you learn about one tiny aspect of SQL...

And enjoy yourself!!!

Have fun, joke with friends and co-workers, smile, take "fun breaks", run to Dairy Queen/Starbucks/Jamba Juice, keep a football around and throw it with a friend for 5...

Redd has a great explanation and I'll just add my little bit to it.

The memory above 4GB is "swapped" or "mapped" (not sure which) down into the OS section of...

I've heard great things about both Red Gate and Innovartis (dbGhost) as products from people. Haven't really used either, but people seem to like both.