Edit: So sorry to those who couldn’t find the page from the SQLServerPedia syndication! The video can be found on our front page on MidnightDBA.com. A love letter, from Sean to you: Let’s do a quick one-day contest because I’m in a good mood on a Friday. The latest video I posted, “Check if File Exists”…why did i make […]
Category: Uncategorized
Correlating Data in SQL Trace, Part 2 – in which Johnny learns a valuable lesson
In last week’s “Correlating Data in SQL Trace, Part 1”, we took a trace to diagnose lock timeouts, and developed a query to correlate lines in the trace: this let us see what code was generating what lock timeouts. The trick for the query is to use a correlated subquery to find the statement rownumber, […]
Win a MS Lifecam this month!
Cause we are living in a material world, and you are a material girl! Free stuff is awesome, and we only have, like, two people who actually read the blog, so odds are good! Your odds are good this month on winning a Microsoft LifeCam Show! Just email jen@jennifermccown.com with an answer to: What does Sean […]