I tend to agree that government regulation is troublesome, but I also see that forcing Microsoft to deliver patches in some reasonable time makes sense. It's easy for either group...

The cycling was getting me too. The best way, IMHO, is a hash table of some sort for each bucket, tracking the changes in a row by row basis. That's...

, cut and paste from an earlier article for some sections. Guess that didn't work out so well.

Can't believe it's Sept already. Broncos tickets...

Not sure about either of those.

I think Denver has lagged at times behind other areas in the country, especially considering the cost of living here. The last 3 DBA jobs...

Do you mean queried (Read only)? There's no way to do this other than use Profiler to track access. For writes, it could be done with triggers.

I guess you could...

You need to provide some example of what you are trying to do. That's too open ended a question.

It doesn't matter which comes first in the WHERE clause. Either one can be there and the optimizer will decide how to join the tables on its own.

Some of these are system processes (Task Manager, etc.) so there's nothing to do with these. The Awaiting Command ones are usually idle client connections.

How much free space do you have in you database v the size of this table? Maybe there's no enough extents in a row to build the table. You might...

You could set up a check for the file timestamp with a script of some sort. In SQL 2000, I'd probably set a DTS package that uses VBScript to check...

Denis,

I'm not sure there's an easy way to run this report without performance issues. You can set up a clustered index on the date, which will limit he amount of...

I'm not sure how many times you should go through the book, but you should be able to add/delete/edit the following:

- Logins

- Users

- Databases

- Schemas

- Roles

- Permissions to any object...

I took this after writing part of the Sybex book. It was fairly routine and I didn't think it was overly difficult. Of the 4 I've done (431, 441, 443,...

Doing some projects would definitely help and I'd consider them. Especially if you could bring a version to teh interview on a laptop, explain how/why things work.

I'm not saying you're...

Michael has it right. Look up Multi-Server Admin in BOL or Master Server/ Target Server.