Bio-diversity is why we haven't been wiped out by

a) The black death

b) Smallpox

c) Flu

d) Umpteen others

I agree with pg53. The key is that the people managing these diverse technological...

Now if only that worked on girlfriends.

The problem with COMMIT TRANS in this case is that it results in a wife and massive consumption of resources.

ROLLBACK TRANS and your handling...

Been there, done that.

To be honest, when I have a single record update I open up the table in Enterprise Manager and edit the record manually. You can't accidentally...

It doesn't do any harm to code SELECT 1 FROM etc

Playing devils advocate I would say that

a) It emphasises that this SELECT statement is for a specific purpose

b) SELECT *...

Apparently not because EXISTS short-circuits

Is that a dagger I see before me?

If you put a clustered index on something it is best done on a field that is naturally ordered such as a sequential id field.

Income tax was originally a temporary taxation. Speed limits on motorways were originally temporary so I would be wary of SMALLDATETIME. Admittedly we will all be dead by...

At least our bodily parts will remain attached.

Lets see if I understand your method Chris.

dbo.INDICATORTABLE contains a single record with the uniqifier field set to 1.

All you do is set the value of othertablepk to the primary...

Yes,

Firstly, add the NT Account under which MSSQLSERVER service starts up to your server. This should be a domain account, not LOCALSYSTEM.

Grant it SysAdmin rights.

Remove BuiltIn/Administrators

Be careful if you...

Certain kitchen cleaning products, such as bleach, damage your fingerprints. Yet another reason to delegate domestic chores!

I my setup my MSSQLSERVER and SQLSERVERAGENT account are running with a domain account with minimal permissions to the domain but in the Administrators group of the SQL Server.

Yes, I...

I agree with you on the importance of DBAs.

The big problem is that the title DBA has been down-graded in the minds of those hiring them. I am not...

Using my own personal body parts to secure corporate data?

Look, I'm sure the techno weenies are fainting with pleasure over this but I've seen "Demolition man" with the eyeball on...