Viewing 15 posts - 871 through 885 (of 1,348 total)
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...
April 14, 2008 at 11:09 am
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...
April 10, 2008 at 1:48 pm
you can try on the distributor by renaming them, but i don't see the point
March 27, 2008 at 11:51 am
not the best solution, but you can replicate the data to a single db or to a central location and backup from there
March 27, 2008 at 11:49 am
Michael Earl (3/27/2008)
March 27, 2008 at 11:45 am
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
March 26, 2008 at 1:31 pm
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...
March 26, 2008 at 1:30 pm
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...
March 26, 2008 at 1:20 pm
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...
March 26, 2008 at 12:38 pm
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...
March 24, 2008 at 12:43 pm
just stick to only rebuilding indexes as part of maintenance and no need to run update statistics
March 24, 2008 at 12:39 pm
check the configuration manager, in RTM by default all the protocols are shut down. pretty sure SP2 gets rid of it
March 18, 2008 at 9:27 am
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
March 18, 2008 at 8:59 am
no, it will stop the sql service
March 5, 2008 at 10:23 am
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...
March 5, 2008 at 9:09 am
Viewing 15 posts - 871 through 885 (of 1,348 total)