Viewing 15 posts - 1,006 through 1,020 (of 1,348 total)
HP recently came out with the DL 580 G4. 4 quad core CPU's and with next year's RAM it will support up to 256GB of RAM per server
if you need...
October 31, 2007 at 1:58 pm
it's in the windows 2003 documentation, but something like this
cmd
diskpart
select disk #
create partition primary offset = 64
than give it a drive letter and format with 64k alloction units
it won't really...
October 31, 2007 at 12:21 pm
had a similar issue where db with around 300 tables would get tons of errors in replication
we fixed it by installing a new distributor running 64 bit SQL and...
October 30, 2007 at 1:50 pm
search for posts under my username. i posted our process a few months back
October 2, 2007 at 2:04 pm
if OP wants i can post our blocking script
we have a table where we write data to from sysprocesses every 2 minutes and if there is blocking it sends an...
October 2, 2007 at 2:02 pm
first i would try to drop and recreate the index. i've seen instances where it's not fragmented, but it won't use an index seek for some reason until you rebuild...
October 2, 2007 at 11:46 am
first you run the snapshot agent to create the snapshot, then the logreader and then run the subscription the first time and it will apply the snapshot
October 2, 2007 at 10:27 am
no can do, i get an error about the db being part of the replication or something like that
October 1, 2007 at 6:11 pm
you can also do an sp_who2 and the app name will say SQL Profiler
September 25, 2007 at 8:40 am
i think it wants you to migrate them to SSIS
September 21, 2007 at 8:29 am
i had something similar. i had to create almost every single column manually by specifying the length. took me a few days
September 21, 2007 at 8:25 am
unique index means unique values. you have to find the duplicate values and delete them or create a non-unique index
September 21, 2007 at 8:21 am
i think it's going to create a separate instance which will use up more resources. if you want a local db service on your PC i would suggest uninstalling SQL...
September 21, 2007 at 8:16 am
i have it running on Vista Business. you install it, then install SP2. MS says that it won't work on Vista unless you have SP2
September 21, 2007 at 6:46 am
it depends on the model of the RAID controller. i changed this on a DL 380 G5 recently and no rebuilding required. it will warn you if it requires rebuilding...
September 20, 2007 at 7:15 am
Viewing 15 posts - 1,006 through 1,020 (of 1,348 total)