Home Blog Page 3

A Year of Tuesdays: T-SQL Tuesday Meta-Roundup

Just over a year ago I kicked off T-SQL Tuesday, "a recurring, revolving blog party." The idea was simple: Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to participate is invited to write a post...

Revisiting ISNULL, COALESCE, and the Perils of Micro-Optimization

Almost six years ago--in November of 2004--I posted what would turn out to be one of my most popular blog posts in terms of number of reads, "Performance: ISNULL vs. COALESCE." (If you're curious, the post is dated July 2006 because I was too lazyit was difficult to transition the publication dates over with...

Smashing a DMV Myth: session_id > 50 == User Process

Ever since I started working with SQL Server, I've been seeing advice to filter system views based on session identifiers, in order to return only user processes. The general advice is to look for session IDs (or SPIDs) greater than 50. And this seems relatively safe if you look at the system views on...

T-SQL Tuesday #007 and T-SQL Tuesday Has a Logo

This month’s T-SQL Tuesday is hosted by Jorge Segarra, the “SQL Chicken.” The topic is rather open ended: What is your favorite new(ish) SQL Server feature? Love the DACPAC? Can’t wait for PDW? Post about it and tell us why!In other T-SQL Tuesday news, we now have a logo. Those of you who are...

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. Today we'll take a look at the settings and options that influence intra-query parallelism and...

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 Operating System schedules its many active threads, and the differences...

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 problems faster. Now quit imagining that, because you're human and you're...

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 present version 1.001, attached to this post.Enjoy, and...

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!

A Warning to Those Using sys.dm_exec_query_stats

The sys.dm_exec_query_stats view is one of my favorite DMVs. It has replaced a large chunk of what I used to use SQL Trace for--pulling metrics about what queries are running and how often--and it makes this kind of data collection painless and automatic. What's not to love? But use cases for the view are...

Popular Posts