February 2007 - Posts
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
Read More...
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
Read More...
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 a more
Read More...
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 what
Read More...
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 AS 2000
Read More...
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 so we
Read More...
