Just to clarify, the 20% increase is compared to the same cached query of the non-compressed database.

Times:

non-compressed first run 2 minutes, second run 11 seconds

compressed first run 1 minute, second...

No, haven't tried page level yet. Our redgate compressed backups went down from 40gigs to 24gigs for the compressed database. Compression is going to be huge for us...

We have a warehouse database that is normally around 400gigs which compresses down to 80gigs with row level compression. Performance of queries varies widely depending on the disk io...

Giving direct access to users is a bad thing. Granted a savy user may be able to figure out a sp. However, even casual users have access to...

We have 7 large sql 2005 servers with 8-16 cores and 32-64 gigs of ram running windows 2003 64 bit. Benefits we have seen are as follows:

- Stability

- Large...

Steve, what type of load information are you looking for?

I can summarize some of our findings of moving to sql server 2005 64bit.

From a warehousing perspective we have seen huge...

We have moved many of our databases from 32bit 2000 servers to 64bit 2005 servers. Hardware is similar between 32bit and 64bit with the exception of 16gigs of ram...

Thanks for the advise.  I am using as2k5.  If I can use a sp, that would be great since I could easily pass in the weighted average, round it and...

That worked.  I had tried doing it with a calculation based on non-additive measures, but that didn't work.

Anyone know how to do lookups with measures and display character values?  Now...

Create a dts package that dumps your cusip/ticker list to a text file, ftp's the list to your data provider, ftp's the prices back and then loads them into the table used...

Option A also keeps your logic out of the report, which turns the report into just a formatting tool.  This allows other tools, such as excel, to use the same...

Opps, I meant "This will tell you how many seconds your data is staying memory withOUT references".  My typing is slower than my thoughts this morning.

Try monitoring page life expectancy under buffer manager.  This will tell you how many seconds your data is staying memory with references.  A general rule of thumb I read somewhere...

I think you will have to take one cpu out or purchase another cpu license.

The $19,000 is the retail price per cpu for sql enterprise.  The $3,200 was probably either sql standard per cpu, sql standard per seat with 25 cals or enterprise per seat with...