Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server Advent Calendar 7 – Partitions & Indexed Views

Day 6 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Indexed Views allow result sets to be persistent as they are materialized on physical storage which avoids performing costly joins and/or aggregations at execution time.  However in SQL Server 2005 they would have to be dropped and recreated if one… Read more

SQL Server BI Everywhere

Nearly everything Microsoft brings out these days has a SQL Server back-end, except Exchange as Eileen will tell you.  I got asked about cubes in Project Enterprise server recently and managed to resolve an issue with the data not being updated due to a connection problem. In a similar vein, I have been helping out… Read more