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.
Read More...
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
Read More...