It's a new year and, with it, we come bearing gifts! We have a pretty significant update to SQL Server 2005 Best Practices Analyzer. It contains many new and updated rules for Analysis Services, a few important rules for the Relational Engine, a couple bug fixes for the UI and command line tools. And all of these rules have rich documentation telling you what need to know.
...
Read More...
Scale-Out Querying with Analysis Services Using SAN Snapshots
Read More...
Author: Bren Newman Introduction When using Microsoft SQL Server 2005 Transactional Replication, the Log Reader Agent reads the log, constructs SQL statements for published articles and posts it to the Distribution database; the Distribution Agent reads
Read More...
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise
Read More...
Question 1: How can SQL Server 2005 OnLine Piecemeal Restore improve availability? Question 2: Can I recover a single object such as a table or specific partition(s) from a partitioned table? Answer: The question is how to get the greatest flexibility,
Read More...
