Browse by Tags

• Automation
• Batch Size
• Data Load
• parallelism
• Performance
• Replication
• SqlBulkCopy

• 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 Read More... Posted Friday, July 08, 2011 1:19 PM by Linchi Shea | 1 Comments Filed under: Automation, Multi-threading, parallelism, Replication

• 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 Read More... Posted Friday, July 01, 2011 12:54 PM by Linchi Shea | 4 Comments Filed under: Batch Size, Data Load, Multi-threading, parallelism, Performance, SqlBulkCopy

• 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 Read More... Posted Monday, August 02, 2010 10:28 AM by Linchi Shea | 12 Comments Filed under: Multi-threading, parallelism, Performance