Wednesday, June 30, 2004 - Posts

Tips for Optimising Reporting Services Performance from tudortr

tudortr has some tips on measuring and improving Reporting Services performance. I heartily agree with number 1: optimise your queries. I've found that using a) proper indexes and b) creating intermediate tables where necessary (possibly containing summarised data from a month that is reported in many different reports, rather than going to the transaction-level original data table, for instance) are the best things I can do to improve performance on my reports.

Media Center Theme for Windows XP

Stefano and Girish inform us that the official Windows Media Center theme (called Royale) can be used on Windows XP. Cool!

I like tweaking my colors but am not willing to load themes from 3rd-party sites on my work PC (or don't want to get busted), so it's nice to have an option. There's instructions on where to copy the theme to in the RAR file, which can be downloaded from Winbeta.

UPDATE: Stefano alerts us that the theme has been officially released (called “Energy Blue“), and can be got here. You'll have to extract the relevant files with WinRAR and copy them manually to your Resources directory, though, as the installer is designed for Tablet PC's only.