i've been at my job for 6 years and we have windows servers that stay up for months at a time with no reboots and no problems. i really don't...

where i work we just restore from tape to dev or QA every month or whenever they request it

i like it a lot better than the sql 2000 version. in one window you can see all your publishers and distributors

when i got the registration error on 2000, i just started registering all the 2000 servers via Management Studio and using SSMS to set up replication and it's been working...

interesting

we have a few SP2 boxes for testing and i have never noticed it, but they are blazing fast. i run update stats via script and dump the command to...

i was going to reply to your last email, but it's been crazy here

in my paranoid mind whenever I do anything like install SQL on a cluster or a service pack i like to do the following.

fail everything over to node A and...

come to think of it, i did find a few syntax and spelling errors in BOL

find the PC/server and see what they are doing or script the index and change it online = on

do you have AWE enabled? also see if you can disconnect and reconnect via management studio.

i just had a problem where i couldn't connect by management studio, got a similar...

haven't installed it on anything with jobs running. Try installing the 3161 hotfix. you have to call MS for it

is there a unique index on the table?

we upgraded our publisher almost a month ago and set up sys.dm_db_index_physical_stats to dump the data into a database. we then run alter index rebuild on anything over 5% fragmented.

i...

BOL said that the only thing changes from 80 to 90 is that with 90 you can do pivot table and a few other 2005 only commands as well as...

awesome article, thanks

we have had a few problems with bad execution plans for no reason we could guess