I don't think it is worth compressing small lookup tables. In fact I noticed that a database containing nothing but small (<100 record) lookup tables actually grew.

Does the concept...

Wish I had a few more databases of sub-billion row tables:-P

The thing that has made MPP so attractive in the BI world is the explosion in data volumes. Not...

Raw space is cheap but IO and concurrency isn't.

One point to watch out for is how well the records fit on a page of data. The first example I...

I think the whole "can be done cheaper in a low cost country" is a case of perception vs reality. The problem comes when it is the perception of...

Solomon Rutzky (12/29/2010)

---

The only issue I have is with your statement that "median" is not a good case for a CLR aggregate as it might "require a substantial portion of...

If I work from home I eliminate a 2 hour round trip commute. This means I can either start earlier or have a lie in. When I finish...

On the subject of the expensive sort in the execution plan I had a note back from Bob Beauchamp saying that there is an internal stream aggregator operation that causes...

One point I forgot to mention was a data warehouse appliance is a self contained unit so you won't be cannibalizing your existing storage and IO. There is obviously...

I thought SWITCH only worked in Enterprise Edition?

If you have...

In the rare cases when I've felt the need for RBAR I've found that in some cases cursors are faster than WHILE loops but only when I don't have to...

IBM has acquired Neteeza.

http://www-03.ibm.com/press/us/en/pressrelease/32955.wss

I wrote up my thoughts on MPP appliances earlier this year http://www.sqlservercentral.com/articles/MPP/70845/.

They are not a marketing hype thing. Green plum has been bought by EMC, Neteeza has been bought...

Another easy mistake to make is to put a clustered index on the view that conflicts with the clustered index in the base tables. I now hold the world...

grahamc (11/15/2010)

---

Well one argument (not seen in this thread yet) for the case of using NULL values is the introduction of SPARSE columns. This link discusses the space savings based...

There are subtle differences between the different RDBMS's that mean chop and change may not be as cheap as it should be.

You could be faced with quite a bit more...