Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 10, 2012
Working in the SQL Server emergency room, I see a lot of self-inflicted performance wounds. That query looks good, and it looks like it's using an index -- but why does it take so long? The query runs great half the time, but the rest of the time performance is cut off at the knees, and the only fix is to restart the server. Learn the top 3 T-SQL traumas I see in consulting engagements, and find out whether they're affecting your environment.