Query Tuning Mastery at PASS Summit 2012: The Demos

Posted by Adam Machanic on SQL Blog See other posts from SQL Blog or by Adam Machanic
Published on Mon, 12 Nov 2012 04:00:00 GMT Indexed on 2012/11/12 5:08 UTC
Read the original article Hit count: 450

Filed under:

Parallel Processing

|

PASS

|

Performance

|

Query Tuning

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 overflow for the keynote, following a keynote speaker that didn't stop speaking on time. Frustrating! Last Thursday, after very, very quickly setting up and...(read more)

© SQL Blog or respective owner

Related posts about Parallel Processing

Going Parallel with the Task Parallel Library and PLINQ

as seen on Internet.com - Search for 'Internet.com'
With more and more computers using a multi-core processor, the free lunch of increased clock speeds and the inherent performance gains are over. Software developers must instead make sure their applications take use of all the cores available in an efficient manner. New features in .NET 4.0 mean that… >>> More
configure Squid3 proxy server on Ubuntu with caching and logging

as seen on Server Fault - Search for 'Server Fault'
I have a ubuntu 11.10 machine. Installed Squid3. When i configure the squid as http_access allow all, everything works fine. my current configuration mostly default is as follows: 2012/09/10 13:19:57| Processing Configuration File: /etc/squid3/squid.conf (depth 0) 2012/09/10 13:19:57| Processing:… >>> More
Parallel Desktops: installing Parallel Tools on Ubuntu

as seen on Super User - Search for 'Super User'
hi, I get the following error when I try to install Parallel Tools on my Ubuntu in Parallel Desktop. I follow the istructions, running sh install from terminal: I follow the UI istructions and then the installation stops with this error message: E: Couldn't find package dkms Fri May 7 14:34:20… >>> More
Improving Partitioned Table Join Performance

as seen on SQL Blog - Search for 'SQL Blog'
The query optimizer does not always choose an optimal strategy when joining partitioned tables. This post looks at an example, showing how a manual rewrite of the query can almost double performance, while reducing the memory grant to almost nothing. Test Data The two tables in this example use… >>> More
apt-get fails to upgrade, install, remove etc

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I upgraded from 11.10 to 12.04, had no issues that I noticed. Recently tried to install something via software center, but it was throwing errors. Changed to trying to sudo apt-get install instead but again no luck. I've genuinely tried as much as I know to fix this, but I can't so I figured I'd ask… >>> More

Related posts about PASS

pass by reference or pass by value?

as seen on Stack Overflow - Search for 'Stack Overflow'
When learning a new programming language, one of the possible roadblocks you might encounter is the question whether the language is, by default, pass-by-value or pass-by-reference So here is my question to all of you, in your favorite language, how is it actually done? and what are the possible… >>> More
24 hours to pass until 24 Hours of PASS

as seen on SQL Blog - Search for 'SQL Blog'
There’s a bunch of stuff going on at the moment in the SQL world, so if you’ve missed this particular piece of news, let me tell you a bit about it. Twice a year, the SQL community puts on its biggest virtual event – 24 Hours of PASS. And the next one is tomorrow – March 21st, 2012. Twenty-four sessions… >>> More
24 hours to pass until 24 Hours of PASS

as seen on SQL Blog - Search for 'SQL Blog'
There’s a bunch of stuff going on at the moment in the SQL world, so if you’ve missed this particular piece of news, let me tell you a bit about it. Twice a year, the SQL community puts on its biggest virtual event – 24 Hours of PASS. And the next one is tomorrow – March 21st, 2012. Twenty-four sessions… >>> More
Thoughts on the Nomination Committee Campaign 2014

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Congratulations to Erin, Andy and Allen on making the Nomination Committee for 2014. As Mark Broadbent (@retracement) stated in his tweet, there’s a great set of individuals for the Nom Com, and I could not agree more. I know Erin and Allen, and I know how much value they will bring to the process… >>> More
C# - Pass by value & Pass by Reference

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Team, Could you please explain the following behavior of C# Class. I expect the classResult as "Class Lijo"; but actual value is “Changed”. We’re making a copy of the reference. Though the copy is pointing to the same address, the method receiving the argument cannot change original. Still… >>> More