Michaeljswart - michaeljswart.com - Michael J. Swart
General Information:
Latest News:
A Tuning Technique For Parallel Queries 15 Aug 2013 | 09:00 pm
Takeaway: I describe a technique I use to tune parallel queries. I tune the serial version of the query using MAXDOP 1. It’s a simpler query plan. Faster understanding leads to faster solutions. How ...
Lessons From Sherlock Holmes 30 Jul 2013 | 08:41 am
Last year, I wrote the article Lessons From Geordi Laforge and I had a ton of fun doing it. So I’m writing a bit of a follow-up article for another fictional hero of mine, Sherlock Holmes. It’s a fun ...
It Took Me Ages To Figure This One Out: A Puzzle 3 Jul 2013 | 09:00 pm
Takeaway: I tackled a problem recently and I present a version of the problem here as a challenge. The challenge is to figure out why a query and a stored procedure return different results even thoug...
Swart’s Ten Percent Rule 28 May 2013 | 09:00 pm
“Just because you can, doesn’t mean you should.” SQL Server has a number of limits and restrictions (many of the limits are described here). Most of the time these restrictions don’t feel restrictive ...
Myself in 2004 14 May 2013 | 08:53 pm
This is me in 2004. This picture was taken in an electronics factory in Zhongshan, China.
The Sch-M lock is Evil 17 Apr 2013 | 09:00 pm
A necessary evil, but still evil. Why? Because it it won't share with Sch-S and Sch-S is taken and held for absolutely everything
T-SQL Tuesday #41 – Presenting and loving it? 9 Apr 2013 | 05:00 am
In Bob's TSQL Tuesday invitation, he asks us "How did you come to love presenting?" I'll let you know when and if that ever happens.
Splitting Time Between Hobbies 3 Apr 2013 | 09:00 pm
Google reader is dying, but I don’t think it’s the end of RSS and blogs. Blogs, I think, will always be a great medium for technical communities. But it has got me thinking about where and how I spend...
Altering Text Columns: Only a Metadata Change? 3 Apr 2013 | 05:00 pm
It can mean the difference between a maintenance window that lasts five minutes, or one that lasts five hours or more.
Checking Out Amazon Redshift 19 Mar 2013 | 11:00 pm
So when Amazon came out with a publicly available Beta for their new Redshift Datawarehouse service, I decided to kick the tires.
