Company I work for doesn't provide laptops. We all work on desktop machines.

I bought my own laptop, and while I do sometimes do work on it, it is my machine...

Sorry, for some reason I read that as Will Not.

I thought of that, and it's certainly an option. I'm hoping for a quicker way.

With login failures and backup logs and the like, my error logs often reach a couple...

The too many rows would be the big one. I can't offhand think of another reason.

Say the NC is on MyDate and returns 100 rows. That means over 100 random...

Count(*) returns the number of rows

Count(<column&gt returns the number of non-null values in that column.

In your case,

 select count(age) from dependent where age is...

Sorry, I don't fully understand your schema, or how stuff relates to each other.

If you invoice someone for 1000, what gets added to what table?

If the customer then pays...

The data corruption forum is probably a better place for this than the forum on administration of notification services. That said....

DBCC returns a statement at the bottom stating the minimum...

According to books Online (2005)

The Scan:Started event class occurs when a table or index scan is started.

The Scan:Stopped event class occurs when a table or index scan stops.

I've used them...

Logical fragemntation of 50% is bad, but it's not too bad, especially if it's a GUID cluster. I've had one up at 99.98%. The extent fragentation is worse. I do't...

December is financial year end for us, so no leave and on call for period 14 dec - 8 Jan for the DBA tem. Pity cause it's wonderful weather here.

Still,...

No need to move the pk, just get the clustered index onto another column. By preference (mine), static, ever increasing, narrow (esp if you have lots of NC indexes), unique.

You...

One other thing, that I forgot earlier.

If you shrink a data file, SQL puts pages anywhere that there's space. A database shrink can completely undo a reindex.

Your order should be...

I can answer a couple of those:

I have read best-practice for when not to use GUID such as for a PK. Does having GUID PK create wacky indexing due to...

With that number of rows that you want to delete and the few that you need to keep, I'd suggest that you copy the rows you do want to keep...

The exam skill set is listed on the following page.

http://www.microsoft.com/learning/exams/70-431.asp

Before you ask for, or use brain dumps, etc, you should be aware that these are illegal.

Anyone who gives you...