SQL Server Performance

Best Practices, Tips, Benchmarks, Troubleshooting and Monitoring - SQL Server, ADO.NET, Analysis Services, and SSIS

Browse by Tags

Tagged Content List
  • Blog Post: The “Balanced Data Distributor” for SSIS

    The “Balanced Data Distributor” for SSIS Len Wyatt, SQL Server Performance Team There is a new transform component available for SQL Server Integration Services. It’s called the Balanced Data Distributor (BDD) and the download is available here . The BDD provides an easy way to amp...
  • Blog Post: An ETL World Record Revealed (Finally)

    We suppose a more appropriate title would have been: Better Late Than Never. David should begin by apologizing. Last month was the first anniversary of the ETL world record we set last year with SSIS, loading 1 TB of data in under 30 minutes. While Len did a nice blog post on the project at the time...
  • Blog Post: Windows Server 2008 + SQL Server 2008 = Geo-replication Benefits

    After running an experiment, using datacenters on each coast of the U.S., our friends in MSCOM ops verified that the combination of Windows Server 2008 and SQL Server 2008 are great for enabling database geo-replication, thanks to a 100X gain in performance. The experiment provided sufficient evidence...
  • Blog Post: SQL Server 2008 is on its way with great performance

    Just left the final shiproom meeting for SQL Server 2008, and am happy to say every team has signed off, so the product is now in the hands of manufacturing, and in process toward web and media availability for you. We've shipped! MSDN and TechNet subscriber downloads are now live, with more to come...
  • Blog Post: ETL World Record!

    Today at the launch of SQL Server 2008, you may have seen the references to world-record performance doing a load of data using SSIS. Microsoft and Unisys announced a record for loading data into a relational database using an Extract, Transform and Load (ETL) tool. Over 1 TB of TPC-H data was loaded...
Page 1 of 1 (5 items)