One thing I thougth about after my previous post, was the effect of adding more RAM to the server instead of using the directCache technology. Apart from the obvious problem...

Memory is all 28 Gb( 4 Gb left for OS) allocated to SQL server.

/S

CPU's are only running at 65-80 %, it's dual CPU dual core machine, part of it is due to calculations taking place in the ETL process. The only waits I...

Hi again,

I have done some more testing and one thing that took me by surprice at first , was the fact that compressed tables are slower on SSD drives....

Running a...

Hi,

I have been testing a ECZ RevoDrive 480 Gb for a couple of days now and I must say I'm very impressed.

I setup a new development environment for a datawarehosue...

Hi, I got the exact same error today.

The dtsx package works fine when executed from

Execute package utility, but when I try to run it as a scheduled job

I...