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 » parallelism » Multi-threading   (RSS)
  • Why is it good to be comfortable with multi-threading?

    If you are an application developer, you should find a new job if you can't do multu-threaded programming. What if you are a DBA? Probably not, not to the same extent anyway. Some in our community clearly realize the importance of being able to do things in parallel. Adam Machanic, for instance, has put in a lot of efforts in this area and ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 8, 2011
  • 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