Turns out they were using an Excel pivot table to query a 17GB table. The server powering this database is what I’d describe (at best) as “departmental” - a 32 bit OS, only 4GB of RAM, and plenty of other databases on it that typically …

View original here: 
Todd McDermid's Blog: Converting to a Star Schema for Performance …