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 » parallel processing   (RSS)
Showing page 1 of 3 (21 total posts)
  • Re-Inventing the Recursive CTE

    Working with hierarchies in SQL Server never fails to be absolutely fascinating. On the face of things they’re super-easy to model and seem to fit perfectly well: parent_key, child_key, self-referencing FK, and you’re done. But then you go to query the thing and there is a complete breakdown. Prior to SQL Server 2005 the product included zero ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 7, 2015
  • New Book! T-SQL Querying with Itzik Ben-Gan, Dejan Sarka, Kevin Farlee

    I'm excited to announce that after a year of work, T-SQL Querying is now available in e-book form (dead trees will ship next month)!  As you might guess from the author list, this book goes deep into various aspects of T-SQL -- both from querying and query processing perspectives. The book includes Itzik's signature T-SQL coverage, data ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on February 26, 2015
  • Parallel Performance in London: SQLbits XIV, Superheros Edition!

    I'm happy to announce that I'll be returning again this year to the UK's premier SQL Server conference, SQLbits. This year's show is in London, and has a Superheros theme; it should be a great time. On Wednesday March 4th, I'll be delivering ''Better Performance Through Parallelism'' as a full-day preconference seminar. This seminar teaches you ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 18, 2014
  • PASS Summit 2014: Manhandling Parallelism - Demos

    Just a quick post to say thank you to everyone who attended today's Manhandling Parallelism talk! I hope you had even half as much fun as I did. For those of you who didn't attend, the talk was recorded and broadcast on ''PASS TV,'' and I'm sure it will be available somewhere soon for on-demand viewing. The demos are attached. Let me know in the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 6, 2014
  • PASS Summit 2014 and the Contradiction of Long Running Things

    As database professionals, I find that one simple thing unites us in our mission, above all else: we absolutely hate long running things. I'm with you. I'm here for you. I want to help you reject long running things. PASS Summit 2014, the premier SQL Server conference of the year, is returning to Seattle this November. And I am returning to PASS ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 17, 2014
  • 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
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement