I know we all see tweets fly by and emails pop up that talk about reserving time on your calendar for something…maybe a webinar, a user group meeting or even SQLRally or the Summit. This request isn’t all that different; yet it is. You ready? Open up your calendar, browse to Saturday and block off…
Finding User Created Statistics
Every so often we hear from a customer who gets a variation of this message when trying to upgrade their database to a newer version of our application: Msg 5074, Level 16, State 1, Line 1 The statistics ‘my_stats’ is dependent on column ‘column1’. Msg 4922, Level 16, State 9, Line 1 ALTER TABLE ALTER…
Meme Monday: Eleven Words or Less
Profiler : unfiltered :: train : wreck This post is part of Tom LaRock’s Meme Monday series ( @SQLRockstar ). I was tagged by Jeremiah Peschka ( blog | @jpeschka ) and Dave Howard ( blog | @DaveH0ward ) and challenged to write a SQL blog post in 11 words or less. SAT analogies popped into…
Lost: Rows from a Merge Join
I worked on a very bizarre customer issue today that I thought I would blog about. I’m curious to see what thoughts people have. I need a new perspective on it since I can’t seem to figure out what to investigate next. Here’s the setup… The problem was described as a search in one area of our…
