Viewing 6 posts - 1 through 6 (of 6 total)
San-847017 (10/26/2009)
Yeah...If it's 32 bit you will have to enable AWE option.In 64 bit it's not necessary.
I enabled AWE option but still couldn't increase server memory.
October 27, 2009 at 12:16 am
My server is window server 2003 and 32 bit.
October 27, 2009 at 12:13 am
I've used SSIS to import. I also had to split the big file into smaller, 5GB for each. That is better and just want to make sure it's ok when...
October 15, 2009 at 1:16 am
I receive a 150GB (maybe more) flat file from customer regularly. And It will take me 2 or 3 days to import into DB. In that case, re-design DB is...
October 11, 2009 at 9:24 pm
Please see my attachment for table detail. I tried running "select distinct STATE_3038 from table" query and it took me more than 20 minutes to complete. Or run query like...
October 10, 2009 at 6:16 pm
Hi JDixon,
Thank for reply.
Running the count is just a sample query. What I do in this case? Increase memory or buy new CPUs?
October 10, 2009 at 1:01 am
Viewing 6 posts - 1 through 6 (of 6 total)