<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.1" -->
<rss version="0.92">
<channel>
	<title>SQL Fool</title>
	<link>http://sqlfool.com</link>
	<description>Adventures in SQL Tuning - a blog for the rest of us</description>
	<lastBuildDate>Wed, 03 Feb 2010 22:47:55 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Filtered Indexes Work-Around</title>
		<description><![CDATA[Recently, I needed to create a stored procedure that queried a rather large table.  The table has a filtered index on a date column, and it covers the query.  However, the Query Optimizer was not using the index, which was increasing the execution time (not to mention IO!) by at least 10x.  [...]]]></description>
		<link>http://sqlfool.com/2010/02/filtered-indexes-work-around/</link>
			</item>
	<item>
		<title>Index Defrag Script Updates &#8211; Beta Testers Needed</title>
		<description><![CDATA[Update:  Wow!  I&#8217;ve received a ton of responses to my request for beta testers.  Thank you all!  The SQL Community is really amazing.  I&#8217;ll hopefully have the new version online in just a few days.   
Over the last few months, I&#8217;ve received many great comments and suggestions regarding [...]]]></description>
		<link>http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/</link>
			</item>
	<item>
		<title>Replication Bug with Partitioned Tables</title>
		<description><![CDATA[Recently, we came across a bug in SQL Server 2005 on one of our production servers.  Apparently, if you execute an ALTER TABLE statement on a replicated table with more than 128 partitions, the log reader will fail.  A relatively obscure bug, I know.  Microsoft has recognized this as a confirmed bug, [...]]]></description>
		<link>http://sqlfool.com/2009/11/replication-bug-with-partitioned-tables/</link>
			</item>
	<item>
		<title>Live Blogging:  Women In Technology Luncheon</title>
		<description><![CDATA[I was invited to live-blog for the Women In Technology (WIT) luncheon at the Summit on Tuesday.  As was the case with all of my &#8220;live blogging,&#8221; I mostly updated Twitter with near-real-time updates, which I then attempt to transcribe into a blog post for later reference.  So here follows that transcription.   [...]]]></description>
		<link>http://sqlfool.com/2009/11/live-blogging-women-in-technology-luncheon/</link>
			</item>
	<item>
		<title>Live Blogging: Keynote at PASS, Day 3</title>
		<description><![CDATA[Today is the 3rd and final day of keynotes at the PASS Summit.  Following is highlights of the keynotes.  During the keynote, refresh often for updates!
8:36 AM PST
Keynote kicks off with Don&#8217;t Stop Believing by Journey.  Awesome.
8:38 AM PST
PASS VP of Marketing Bill Graziano just takes the stage.  He promises the [...]]]></description>
		<link>http://sqlfool.com/2009/11/live-blogging-keynote-at-pass-day-3/</link>
			</item>
	<item>
		<title>Live Blogging: Keynote at PASS, Day 2</title>
		<description><![CDATA[So today is day 2 of the PASS Summit conference.  The conference has been excellent so far, with tons of great content and tons of great folks.  Yesterday&#8217;s keynote revealed some interesting tidbits, including SQL Server 2008 R2 setting the world record for TPC-E (transactions per second) and QphH (queries per hour).  [...]]]></description>
		<link>http://sqlfool.com/2009/11/live-blogging-keynote-at-pass-day-2/</link>
			</item>
	<item>
		<title>Live Blogging:  Keynote at PASS, Day 1</title>
		<description><![CDATA[I&#8217;m honored to be invited to live-blog during the Summit keynotes.  Most of my updates will be via Twitter, but I&#8217;ll periodically consolidate and update into blog posts throughout the keynote.  Please check back frequently during the Summit for updates.
8:00 AM PST
Michelle gets situated at the blog table, running late and doesn&#8217;t even [...]]]></description>
		<link>http://sqlfool.com/2009/11/live-blogging-keynote-at-pass/</link>
			</item>
	<item>
		<title>#PASSAwesomeness</title>
		<description><![CDATA[Allen Kinsel on Twitter (@sqlinsaneo) recently started a new Twitter tag, #PASSAwesomeness, about all of the cool things about PASS Summit.  I really like the tag, so I&#8217;m going to blatantly steal borrow it for this post.   
First, and long overdue, I want to give a brief recap of the East Iowa [...]]]></description>
		<link>http://sqlfool.com/2009/10/passawesomeness/</link>
			</item>
	<item>
		<title>Partitioning Tricks</title>
		<description><![CDATA[For those of you who are using partitioning, or who are considering using partitioning, allow me to share some tips with you.
Easy Partition Staging Tables
Switching partitions (or more specifically, hobts) in and out of a partitioned table requires the use of a staging table.  The staging table has very specific requirements: it must be [...]]]></description>
		<link>http://sqlfool.com/2009/10/partitioning-tricks/</link>
			</item>
	<item>
		<title>Why I&#8217;m Blogging Less</title>
		<description><![CDATA[I&#8217;ve received a few questions asking why I&#8217;ve been blogging less frequently, and even one inquiry after my health.  Rest assured, I&#8217;m completely fine.  But there are 2 perfectly good reasons why I&#8217;ve been blogging less these days.
East Iowa SQL Saturday:
I&#8217;m the event organizer for East Iowa SQL Saturday, which is eating up [...]]]></description>
		<link>http://sqlfool.com/2009/10/why-im-blogging-less/</link>
			</item>
</channel>
</rss>
