THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » performance » parallelism » Multi-threading   (RSS)
  • Performance impact: What is the optimal payload for SqlBulkCopy.WriteToServer()?

    For many years, I have been using a C# program to generate the TPC-C compliant data for testing. The program relies on the SqlBulkCopy class to load the data generated as per the TPC-C specifications into the SQL Server tables. In general, the performance of this C# data loader is satisfactory. Lately however, I found myself in a situation ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 1, 2011
  • Parallelism beyond T-SQL

    People can do amazing things with T-SQL alone even when it may not be the best language to use. For instance, T-SQL was never designed or intended as a language to manage running multiple queries concurrently or running queries asynchronously. But I have seen many stored procedures written to start SQL Agent jobs and then manage the termination of ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on August 2, 2010
Privacy Statement