THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » parallelism   (RSS)
Showing page 2 of 4 (36 total posts)
  • Connect Digest : 2012-01-09

    Hide databases from users who shouldn't be able to see them This is a long-standing request from Erland Sommarskog which I've highlighted in previous digests. But the underlying problem keeps coming up in multiple venues, so I thought it would be good to call attention to the item one more time. Some will argue that the contained database feature ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 9, 2012
  • Performance impact: hyperthreading for reporting queries

    There are a lot of questions on hyperthreading, but not a lot of answers.  There is no shortage of opinions, but very few are based on significant first hand experience or solid test data. We know that the hyperthreading technology in the older generations of the Intel processors was not well received by the SQL Server community. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 5, 2012
  • Forcing a Parallel Query Execution Plan

    This post is for SQL Server developers who have experienced the special kind of frustration, which only comes from spending hours trying to convince the query optimizer to generate a parallel execution plan.  This situation often occurs when making an apparently innocuous change to the text of a moderately complex query; a change which ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on December 22, 2011
  • Performance impact: diminishing marginal return on the degree of parallelism

    In commenting on my previous post, Greg Linwood and GrumpyOldDBA raised questions about various implications of parallelism. In this post, I’ll look at the impact of different degrees of parallelism on the query performance. I’ll limit my examination on the same query that uses a Cartesian product temp table, as discussed in the previous two posts ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 16, 2011
  • SQL Saturday 89 - Atlanta GA - Materials

    Last Saturday, September 17, I was lucky to be able to present two sessions at an excellent SQL Saturday in the Atlanta area. The day drew a large crowd and had a great speaker lineup. All in all, a huge success, and a very well-managed event. Congratulations to the organizers! One of the highlights for me, aside from speaking, was helping out ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on September 24, 2011
  • 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
  • Performance, Discounts, and an Excuse to Visit New York City

    A couple of weeks ago I announced a two-day advanced performance seminar in New York City, which will be delivered in July. This seminar will cover SQLCLR and parallelism techniques to help you take performance well beyond the levels that typical tuning exercises yield. Check out the links for more details, including a full outline. Thanks to the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 2, 2011
  • Connect Digest : 2011-05-23

    Next week I'll be up in Alaska for SQL Cruise, so I'll be skipping at least one digest. This week I gathered a few engine-related issues, two involving what the engine does while an index is being created. The most important one, though, at least IMHO, is the first one listed, involving a hashing algorithm fix that is in SQL Server 2008 R2 - but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 23, 2011
  • Two Days of Advanced Performance Techniques - July 14-15, New York City

    I am pleased to announce that I will be delivering two days of training in New York City, July 14 and 15. This seminar focuses on achieving ''next-level'' performance--going beyond that which you can gain via normal tuning methodologies. The vehicles for this performance improvement are two technologies that I've been pushing on this blog and in ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 18, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement