This past weekend I was in Madison, WI for SQLSaturday #118 and it was a fantastic event. Jes Borland ( b | t ) and her team did a great job of hosting their first SQLSaturday and I was honored to present twice. I presented a new session, DBCC Commands: The Quick and the Dangerous,…
Sorting Out the Error “Failed to perform data correlation”
While working with PerfMon data recently I ran into an interesting error when I tried to view it overlayed against a Trace file. If you’re not familiar with that process, I recommend Brad McGehee’s article Correlating SQL Server Profiler with Performance Monitor. I had opened a Trace file and selected a PerfMon file to import. …
Isolation Levels and the Effects on Select Statements, Part II
Last week I wrote a post on Isolation Levels and the Effects on Select Statements, and I had a conversation on Twitter with Rob Farley ( b | t ) regarding one of my explanations. For READ COMMITTED, I had written the following: If data is being modified by a transaction, any subsequent select statement…
Gratitude
Yesterday afternoon I drove up to Southfield, Michigan to present to the Southeast Michigan SQL Server User Group. Joe Fleming contacted me and asked if I would present my Baselines session, which I presented at the PASS Summit last fall. I usually don’t pass up a chance to go to Michigan, and this was the…
