Doh!

That one always gets me. Must be my accent 😉

We also did an article recently on this.

http://www.sqlservercentral.com/articles/Business+Intelligence/61369/

Perhaps you should reschedule if you're not sure which exam you're taking.

Microsoft has the requirements on their site. Search for MCITP Database Developer Certification

Congrats!

I thought 431 was the hardest, but I worked on a book for 443, so that might have helped 🙂

Good luck Gail!

JJ B,

Excellent points and I think I'll actually move into 2 parts from here. One on getting/deciding on requirements and another on the modeling.

Steve

I've seen production servers with 250 databases on them.

As mentioned above, the number of databases doesn't matter. It's what they are doing.

You will want to restore any logs on the secondary that haven't been restored. If you can't get the tails off the primary, then you are stuck and just need...

I'd use the DTS/SSIS wizard. Easier to set this up once, then you can periodically run it against the tables.

You could BCP out/in, http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30027/, use the select from sysobjects to...

You can grant the CREATE TABLE right to someone. Preferably to a role.

http://www.databasejournal.com/features/mssql/article.php/3379521

We've scanned for service accounts, but that might not help with Express/MSDE.

The only good way is to get a list from SMS, then connect to each instance and run select...

Unspecified means there was an error, but no one wrote a handler for it.

You can try a few things. If you can manually run the DTS package, run it against...

Turn it off: http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx

It could cause blocking, but it's a bad idea.

If F is R1+0, I'm not sure that adding one drive and moving logs there helps that much. How much log activity do you see? How many drives are on...

From my understanding, if the query is completely on the remote server, it is passed through (WHERE clause and all). If this is a distributed query, meaning you are joining...

I believe the SQL 2000 standard sees 2 CPU sockets, but the architecture will spread the SQL 2000 threads on 8 cores. I'll ask around and see.