The 'spin-masters' from the great beyond pay you homage ...

Automatic column compression based on cardinality/data type similar to Sybase IQ. Think about the space savings - anywhere from 30-70% !

It seesm that we forgot about the fact that all Blackberry text messages and emails worldwide are routed throuh 2 RIM datacenters. Granted they are on different continents, but it...

If you are using a copy of the same database on both servers, maybe 'stale' staistics.

All I have to say is:

If you do not want to get hit by a train ...

do not sit on the railroad...

If you really want to look at the contents you could try backing up tempdb to a file and restoring it to another database name. Maybe then you could perform...

formatting data and such things like conversion to local time zone settings are generally the responsibility og the front end application - store it in UTC.

For the purist time is time. Why not store things as UTC ?

Here is another method for SQL 200 databases.

Set them to auto-close, then check the errorlog !

Another tool to go with Putty is FileZilla

http://filezilla-project.org/

"Death by SQL'" ... hmmm ... does that make M$ both 'dangerous' and 'suicidal' for doing it in the msdb ???

Nicholas said it all quite succinctly - his outline has been mine since NT 4.0 and SQL v7.0 !!!

It is definitely a case of doing more with less. Automation and software evolution have tread down this path time and time again. Yes, it impacts the profession - but...

We have this issue on an active/passive IBM NUMA cluster ... still looking ... still no noticable performance issues ...

it's a great day !

sunny, not a cloud in the sky, 70, slight southerly breeze ...

just attempting irony is all ...