you can always put tempdb on multiple spindles using multiple files

I think MS did it this way because it would be a nightmare if apps created temp tables in user...

what would be the point?

some weekday humor, but we did crash our Exchange server twice with SQL

one time we wrote a cursor to kill an MS Access connection and email this. the other time...

in our case when the SAN admin maps the new LUN's to the server we have to reboot for Windows to see the new disks

why not replicate the data every minute?

i found that running replication more often results in better performance than less often. my busiest publications run once a minute to keep the...

tried that as well

i think it's at rollback 0% or something like that. been that way for months. been too lazy to reboot it because so many apps point to...

if this instance is going on the physical nodes running the other 3 instances, then you need some common storage to hold the data for this instance as well as...

if your RS is in a different site from the data that's also going to be a performance problem. can you put the RS server in the same site as...

one of our analysts sent me a bunch of queries they run daily for some reports. each one is a select into a temp table, then another select into another...

dump all your logins and any sql login passwords in a file and keep it in a safe place. file server that is backed up, another db somewhere or maybe...

shouldn't be a problem, the standby SQL server will control it's local data files depending on how you configure them.

not the same, but our replicated db's have a different file...

still the same thing

going to reboot it tomorrow night to clear the lock and then detach and will try to reattach with a new ldf

is there any company that buys every version of every piece of software they own for every server?

we have SQL 2005 on the core servers and sql 2000 at some...

tried that, don't work

i personally try to avoid temp tables

i've seen people populate them with tens of thousands of rows and in many cases most of a source table they are selecting from....