The Curious Engineer

All blogs / Databases

Bart Duncan's SQL Weblog

learn.microsoft.com/en-us/archive/blogs/bartd

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
22 from 25 Jul 2006 to 8 Feb 2018
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/bartd/feed.xml

2018 1

  1. Filtered Indexes and Forced Parameterization: Can't we all just get along?

2012 1

  1. Row Goals Gone Rogue

2011 2

  1. Don’t depend on expression short circuiting in T-SQL (not even with CASE)
  2. Living with SQL's 900 Byte Index Key Length Limit

2010 5

  1. Query Hash Statistics, a query cost analysis tool, now available for download
  2. T-SQL UDTs. (Huh!) What are they good for?
  3. SQL Server Sizing Resources
  4. Purging Data
  5. Finding procedure cache bloat

2009 1

  1. Sometimes the Simplest Solution Isn't the Best Solution (The Optional Parameter Problem)

2008 3

  1. Today's Annoyingly-Unwieldy Term: "Intra-Query Parallel Thread Deadlocks"
  2. Defining Complex Server "Health" Policies in SQL 2008
  3. Query Fingerprints and Plan Fingerprints (The Best SQL 2008 Feature That You've Never Heard Of)

2007 2

  1. A simpler way to convert a hexadecimal string to varbinary
  2. Are you using SQL's Missing Index DMVs?

2006 7

  1. Deadlock Troubleshooting, Part 3
  2. Deadlock Troubleshooting, Part 2
  3. Joins Dissected on CraigFr's blog
  4. SELECT from a view slower than "equivalent" SELECT from the base table
  5. Wide vs. Narrow Plans
  6. Limited Statistics Granularity
  7. Why a bad plan isn't necessarily a bug