Craig has a couple of post on SQL Server 2008 Partitioned tables and Partitioned Indexes . Most interesting is the way Criag uses the ShowXMLPlan to explain the concepts. I sort of like this approach and is easy when writing articles. Earlier I used to have difficulty using the Execution Plan snapshot...
Check my blog post on TechNet over Performance Monitoring with SQL Server 2008 here . Feel free to pass your comments.
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services...
Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping...
This community provides a central hub for SQL Server professionals where they can interact with their peers and access SQL Server related technical information that can help empower their SQL Server knowledge. The community website is currently in beta phase and introduces many programs that helps SQL...