Thanks, I'll correct that. Try to avoid not giving a real explanation, but I probably spaced, got lazy, or was in a hurry.

Apologies.

Thanks

Don't forget the salt!!!

Which question is this for?

I vote for lime laws

I always wondered where people from Phoenix went for vacations. A Steven King pilgrimage, perhaps?

I think the US still tends to overwork as...

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...