why the id column? if you are only querying that one column just use it alone in the clustered index. i have tables where i have a int column for...

doublecheck with the SQL 2005 system view for fragmentation since dbcc showcontig is horribly inaccurate

and check for maintenance on the subscriber blocking replication. if you have enterprise edition make sure...

you can try on the distributor by renaming them, but i don't see the point

not the best solution, but you can replicate the data to a single db or to a central location and backup from there

Michael Earl (3/27/2008)

---

You cannot - if you were able to kill a rollback, it would leave your database in an inconsistent state. If you stop and start the SQL...

only solution i found is to terminal server into a server we upgraded where they seem to work

otherwise the best thing to do is to change everything over to SSIS

bottom line is you are going to have a very fast network in between. if something happens and you have to recreate replication or log shipping or whatever you will...

first thing you need to do is save the security log on the server

right click on it and save as

then look in it. i think the event id is 540...

found the problem

this was on our new subscriber that we locked down so even domain admins can't get to it. transfered all the data types to it and gave access...

the new SAS drives are fast

i would consider raid5 for most of the data and separate RAID1 volumes for logs, indexes, any tables you want on a separate filegroup, etc.

i...

just stick to only rebuilding indexes as part of maintenance and no need to run update statistics

check the configuration manager, in RTM by default all the protocols are shut down. pretty sure SP2 gets rid of it

if you can avoid temp table and table variables

i personally prefer to make a view if i can and use that instead of the above

no, it will stop the sql service

why DL 580's unless you need more than 32GB of RAM?

if you wait, i'm pretty sure the DL 380 G6's will be released soon and they should go higher than...