Haven't found a great one, but I haven't used Apex's tool. I'd give that a try and see if it helps you. ER/Studio and ErWin haven't worked well for me.

I doubt the questions change much. There's too much effort into developing the exams and then doing a Beta to allow for change.

I thought that they built exams to...

Greg and Vidhya's advice is good. I'd be wary of allowing developers to manage jobs and packages. They tend to "fix" things on the fly, often breaking others at the...

These two concepts are not necessarily related at all.

A PK defines uniqueness on your data rows. It allows you to find an individual row out of a group. Whether this...

My kids always tell me that they won't spill grape juice on the couch. When I catch them drinking over there, they say that they haven't spilled it, so it's...

A couple of things.

Be sure the remote connection is using TCP/IP on both sides. It must be enabled on the server and set to be used on the client.

Also, if...

All the files are at the bottom of the article. I didn't notice the links internally, which needed to be removed.

The buffer pool.

You might want to read up here: http://msdn.microsoft.com/en-us/library/ms187499.aspx

And those cars aren't perfect. There are "features" on them that don't work. Browse the recall lists and you might be surprised how many things need to be fixed. If...

No hidden files. MDF + NDF(s) + LDF is the database size. Don't forget backups.

It is interesting and the title doesn't help. It's a good thing that so many people want to help, and I can sympathize. Reading 50+ replies is time consuming.

Everyone wants...

usually. Rebuild indexes to defragment. Shrinking usually causes fragmentation.

Assemblies can be flaky if they're 32bit, SQLMail doesn't work, etc. There are potential issues, but if you have a simple db setup, then you should be OK.

The DBA architect is fairly specialized, and I'm not sure how valuable it is.

I'd stick with ITPro as the certification to show off and use on your resume/CV

You could use a union and select a field

if exists ( select ID from sysobjects where ...

...