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 proces... » Performance   (RSS)
  • 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
  • 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
  • PASS Summit 2010 Post-Conference Seminar on Parallel Processing

    I am honored to have been selected for a second year in a row to present a full-day seminar at the PASS Summit. This year's seminar will be a ''post-con'', and will be delivered on Friday, November 12. The title of the seminar is ''A Day of Doing Many Things at Once: Multitasking, Parallelism, and Process Distribution,'' and the focus is on ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 4, 2010
  • PASS Performance Virtual Chapter: Parallelize Your Queries!

    Last month a new PASS Virtual Chapter was introduced, one with a theme that is near and dear to much of what I like to work on: performance. Tomorrow, Tuesday August 3rd at noon Eastern time, the chapter will have its second meeting, and I will be doing the presentation. The topic is Parallelism and Performance. Here's the abstract:In ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 2, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement