Consulting

SQL Server

It was a long time coming and I hope worth the wait. If you have SQL Server 2008 R2 installed on the same box as ClearTrace and you download the latest ClearTrace build (36) you’ll be able to read SQL Server 2008 R2 traces.

I also fixed a bug handling very, very large SQL statements. I encountered an INSERT statement that was 12MB in size. It was storing XML in a database. ClearTrace uses regular expressions to clean up the SQL it finds. Running two dozen regular expressions over this 12MB string caused the application to crash. In this build I’m just skipping any statement over 1MB. I’ll do something a little nicer in the next build.

(And if you don’t want to download ClearTrace you can test the online version at www.TraceTune.com)