May 2010 - Posts

• SQL University: Parallelism Week - Part 3, Settings and Options

  Congratulations! You've made it back for the the third and final installment of Parallelism Week here at SQL University . So far we've covered the fundamentals of multitasking vs. parallel processing and delved into how parallel query plans actually work Read More... Posted Friday, May 28, 2010 9:00 AM by Adam Machanic | 8 Comments Filed under: query processing, parallelism, SQL University, parallel processing, maximum degree of parallelism, cost threshold for parallelism, maxdop

• SQL University: Parallelism Week - Part 2, Query Processing

  Welcome back for the second part of Parallelism Week here at SQL University . Get your pencils ready, and make sure to raise your hand if you have a question. Last time we covered the necessary background material to help you understand how the SQL Server Read More... Posted Wednesday, May 26, 2010 9:00 AM by Adam Machanic | 12 Comments Filed under: query processing, parallelism, SQL University, parallel processing, query plans, showplan xml Attachment(s): machanic_parallelism_sqlu.sqlplan

• SQL University: Parallelism Week - Introduction

  Welcome to Parallelism Week at SQL University . My name is Adam Machanic, and I'm your professor. Imagine having 8 brains, or 16, or 32. Imagine being able to break up complex thoughts and distribute them across your many brains, so that you could solve Read More... Posted Monday, May 24, 2010 9:00 AM by Adam Machanic | 22 Comments Filed under: parallelism, scheduling, SQL University, sqlos, parallel processing

• Five Things To Which SQL Server Should Say "Goodbye and Good Riddance"

  I was tagged by master blogger Aaron Bertrand and asked to identify five things that should be removed from SQL Server. Easy enough, or so I thought... 1) Tempdb . But I should qualify that a bit. Tempdb is absolutely necessary for SQL Server to properly Read More... Posted Wednesday, May 19, 2010 9:16 PM by Adam Machanic | 23 Comments Filed under: goodbye, good riddance

• 24 Hours of PASS: 15 Powerful Dynamic Management Objects - Deck and Demos

  Thank you to everyone who attended today's 24 Hours of PASS webcast on Dynamic Management Objects! I was shocked, awed, and somewhat scared when I saw the attendee number peak at over 800. I really appreciate your taking time out of your day to listen Read More... Posted Wednesday, May 19, 2010 3:57 PM by Adam Machanic | 11 Comments Filed under: DMVs, PASS, 24 hours of PASS, DMFs, 24hop, DMOs, dynamic management Attachment(s): Machanic_24HOP_201005_DMOs.zip

• Extended Events Code Generator v1.001 - A Quick Fix

  If you're one of the estimated 3-5 people who've downloaded and are using my XE Code Generator , please note that version 1.000 has a small bug: text data (such as query text) larger than 8000 bytes is truncated. I've fixed this issue and am pleased to Read More... Posted Saturday, May 08, 2010 8:23 PM by Adam Machanic | 4 Comments Filed under: extended events, code generator, xevent Attachment(s): xe_code_generator_v1_001.sql

• T-SQL Tuesday #006: LOB Data

  Just a quick note for those of you who may not have seen Michael Coles's post (and a reminder for the rest of you): The topic of this month's T-SQL Tuesday is LOB data . Get your posts ready; next Tuesday we go big! Read More... Posted Thursday, May 06, 2010 2:31 PM by Adam Machanic | 1 Comments Filed under: T-SQL Tuesday, #tsql2sday, BLOB, LOB, CLOB

• Visual Studio 2010 and SQLCLR: Some Good, Some Bad

  This past week I've been trying out Visual Studio 2010 for SQLCLR development. Verdict: A couple of nice things, a couple not so nice. In the interest of keeping things somewhat positive around here, we'll start with the good stuff : Pre-deployment and Read More... Posted Sunday, May 02, 2010 6:40 PM by Adam Machanic | 10 Comments Filed under: SQLCLR, Visual Studio 2010, deployment, deploy, problems