Pete Freitag's HomepageCovering ColdFusion, Java, Web Development, and other topicsSpeaking at CFUNITED 2008- June 16, 2008 I can't believe it's already time for CFUNITED again! I will be speaking twice again this year: Thursday 2:45p - Writing Secure CFML Friday 8:30a - Image Manipulation with ColdFusion 8 See you there!http://www.petefreitag.com/item/675.cfm Getting ColdFusion SQL Statements from SQL Server Trace- June 16, 2008 Running a SQL Trace in the SQL Server Profiler can be a great way to track down performance problems in your ColdFusion application. However if you have tried to run one, you probably didn't see the actualy SQL queries your ColdFusion application was sending, only things like this: RPC:Completed exec sp_execute 1,2,4 The reason for this is that ColdFusion's JDBC Driver for SQL Server passes SQL statements through the sp_execute stored procedure, so you are only seeing the stored procedure...http://www.petefreitag.com/item/674.cfm |