SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page . This service pack extends the functionality of SQL Server in many ways. The What's New document highlights the major changes in the Database...

SQL Server does a great job of optimizing processing across a wide range of runtime scenarios, while also providing a flexible configuration and execution environment. One of the tradeoffs associated with this level of flexibility is that different configurations...

Why did we only use the MOLAP storage mode in Project REAL? There is also ROLAP and HOLAP storage, but they weren’t used at all. Also, why doesn’t Project REAL illustrate pro-active caching? The Analysis Services 2005 Performance Guide contains...

Introduction As we started Project REAL , we were fortunate to be able to use multiple machines and SAN devices to test different configurations. At the same time, this presented a challenge in that we needed to keep track of what information was on...

Do you want to know how to get the best performance out of Analysis Services? Whether you have an immediate performance issue or just want to know more about what’s going on in there, this guide will be a valuable resource. Many people used the...

We are conducting a survey to better understand SQL Server workloads. Please consider providing your workload characteristics and hardware configuration to help us better understand the workloads that run on SQL Server. This is a detailed survey...