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 » parallel processing   (RSS)
Showing page 1 of 2 (16 total posts)
  • SQL Saturday Chicago...and the Gentle Art of Planscaping!

    Three weeks from now I'll be visiting Chicago to participate in SQL Saturday. I'll offer two different learning opportunities: On Friday, April 25, you can join me for a full day seminar on parallelism and performance in SQL Server. This class covers in-depth background on the hows and whys behind SQL Server's parallel processing, followed by an ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 2, 2014
  • Query Performance and Parallelism Seminars in Boston and Chicago

    You're a DBA or database developer working on a big (or even big-ish -- doesn't have to be huge) database. Your end-users are doing all sorts of data analysis, and even though you have a pretty beefy server, your queries just don't seem to run as fast as they should. The reason (I bet)? Your queries aren't taking full advantage of the CPU power ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 30, 2014
  • Next-Level Parallel Plan Forcing: An Alternative to 8649

    ''Even experts with decades of SQL Server experience and detailed internal knowledge will want to be careful with this trace flag.  I cannot recommend you use it directly in production unless advised by Microsoft, but you might like to use it on a test system as an extreme last resort, perhaps to generate a plan guide or USE PLAN hint for ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 11, 2013
  • TechEd 2013: Demos for "Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR"

    Today at TechEd in New Orleans I delivered a breakout session entitled ''Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR.'' This session covered a number of techniques for using SQLCLR as a query tuning tool, especially for big, ugly, and heavily analytical queries. Thank you so much for all who attended and took the time ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 4, 2013
  • More Fun in Atlanta: Parallelism at SQL Saturday 220

    May 18, SQL Saturday returns yet again to the Atlanta area. At this point I've become a bit of a regular at Atlanta's events; this will be my third one in a row. The team that puts them together is amazing, and produces top quality, super fun and educational days every time. Plus: Taco Mac. Friday, May 17, the event is running a few ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 25, 2013
  • Query Tuning Mastery at PASS Summit 2012: The Video

    An especially clever community member was kind enough to reverse-engineer the video stream for me, and came up with a direct link to the PASS TV video stream for my Query Tuning Mastery: The Art and Science of Manhandling Parallelism talk, delivered at the PASS Summit last Thursday. I'm not sure how long this link will work, but I'd like to share ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 13, 2012
  • Query Tuning Mastery at PASS Summit 2012: The Demos

    For the second year in a row, I was asked to deliver a 500-level ''Query Tuning Mastery'' talk in room 6E of the Washington State Convention Center, for the PASS Summit. (Here's some information about last year's talk, on workspace memory.) And for the second year in a row, I had to deliver said talk at 10:15 in the morning, in a room used as ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 11, 2012
  • Recent Webcasts on Parallel Processing Available for Download

    While preparing the material for my PASS Summit post-con on parallelism and parallel processing I realized that I could easily take a few chunks out, modify them a bit, and create some nice standalone webcasts. So I did just that, and delivered two sessions, one for the PASS Performance Virtual Chapter and another for the PASS Application ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 7, 2010
  • QueryParallelizer Beta 1

    QueryParallelizer is a .NET component designed to assist with parallel processing and ETL of SQL Server-based data. It can be used either hosted in the SQL Server process as a SQLCLR module, or in an external .NET application. Full documentation forthcoming.
    Posted to Beta Projects (FileGallery) by adam machanic on September 28, 2010
  • Webcast - September 28, 2010 - Next-Level SQLCLR: Parallel Processing and Bulk Load

    Tomorrow at 12:00 p.m. EDT (4:00 p.m. GMT) I'll be doing a webcast for the PASS Application Development Virtual Chapter.Next-Level SQLCLR: Parallel Processing and Bulk LoadThe power of SQLCLR as a performance tool has been well-documented at this point; certain queries, when re-written the right way using SQLCLR components, can run an order of ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on September 27, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement