Viewing 15 posts - 931 through 945 (of 1,348 total)
we only do rebuilds since it saves us from doing an update statistics
we do alter index rebuild with (online = on) and once in a while drop and recreate it...
January 11, 2008 at 11:29 am
i have a process where daily i run the system view to gather the data and then alter index based on the frag data. i have separate db's on each...
January 11, 2008 at 9:59 am
why not a multi-step approach
grab the data out of AD and display the first level of group membership. then run several queries to display the second and third levels and...
January 9, 2008 at 12:28 pm
management studio is installed as part of workstation tools and you should also install SSIS. everything else is a server component
January 7, 2008 at 7:30 am
we have a consultant go into our Great Plains servers once in a while, but that is all they hit. anyone who wants to run anything anywhere else needs to...
January 7, 2008 at 7:25 am
thank you all
working on the code now to rename it with a dynamic name
January 4, 2008 at 10:01 am
if you are allowed, have you tried to alias the domain account you are running sql as to dbo on your servers? there is an sp for it, but i...
December 28, 2007 at 1:29 pm
is there a kb article for this issue?
December 28, 2007 at 11:58 am
not the first time for MS
we had an issue where one replicated table would replicate a lot slower than all others. MS tried to tell me it was a hardware...
December 28, 2007 at 11:24 am
we used to have 2 SQL 2005 SP2 distributors and some time ago migrated to one 64 bit distributor that handles SQL 2005 SP2 and SQL 2000 publications. all transactional.
i...
December 28, 2007 at 10:46 am
or restore it under a different name and different file names or paths
December 28, 2007 at 9:39 am
transactional here and i always use the GUI to create publications and subscriptions
only time i used sp's was when we went to a new distributor a few months back and...
December 28, 2007 at 9:36 am
we had an issue where a select would default to an index scan on the PK because it was grabbing something like 3 million rows and at the same time...
December 28, 2007 at 9:35 am
strange, we do replication from SQL 2005 SP 2 to SQL 2000 and no problems. even reinitialized 2 subscriptions last night to some ancient sql 2000 servers we have. even...
December 28, 2007 at 8:42 am
run snapshot, run logreader and then start the subscrption to start the snapshot to the subscriber
make sure you connect to every server from SSMS
December 28, 2007 at 8:39 am
Viewing 15 posts - 931 through 945 (of 1,348 total)