Harry Callahan: A man's got to know his limitations ... 😉

Take care of yourself and get well Steve !

Yes you can remain a 'techie' ... I'm 51 and been a DBA for 26+ years and still a 'techie' ...

Although I did do the manager thing for a...

Good point Gary, maybe I should have clarified, one or two people could be present to provide 'background noise' (i.e idle chat at times) and also provide the service of...

Here is a rather quick'n'dirty script that we use.

It is an interesting premise. However for a first interview in an alien environment it may not be fair - but you will probably find the best candidates that can...

Skynet begins to learn at a geometric rate. It becomes self-aware at 2:14 a.m. Eastern time, August 29th. In a panic, they try to pull the plug. ...

Glad it was...

self healing or mutation ??? hmmm ... sounds like malware or a virus to me ...

We have 250+ instances

a handful are v7.0

about half are SQL 2000

about half are SQL 2005

we have no plans for SQL 2008 and are waiting until SQL 2010

No degree - I was driven by the potential income when entering college in 1981 under General Studies - I took all of the computer courses required for a BA...

Add the WITH REPLACE clause.

For some reason 4 threads is kind of magical, whether there were 2, 4 or 8 CPUs. It did not matter if the CPUs were physical, hyperthreaded or physical (single...

Striping will only help if your I/O subsystem can handle it.

I have done extensive testing over the years and have found that 4 threads usually gives me the best performance....

Awe come on now Warren - it is just a 'slightly undocumented' feature is all ...

Actually I have seen it work most of the time in batch scripts, however when...

Could you also post an example of the swings in 'page life expectancy' ?

lows and highs from a few random samples would be good.

how is your buffer cache hit ratio...

Could you post your boot.ini file ?

Also, the resutls of the folllowing:

exec sp_configure 'awe enabled'

exec sp_configure 'min server memory (MB)'

...