Browse by Tags

The evils of implicit conversions
18 January 2009 17:18

I wanted to put up a brief post showing the impact of an implicit conversion on the performance of a query (or not......). In the example i will show an implicit conversion negatively impacting query performance and an implicit conversion that does not impact performance..... So, we need to setup the test environment using the code below. SET ANSI_WARNINGS OFF... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SQL 2000, Tips, Performance

A performance analysis example
15 January 2006 17:53

Last week i was dragged kicking and screaming away from my allocated SQL 2005 days to spend 2 days diagnosing performance problems on one of the firms Systems and write a report. Due to the sensitive nature of the data on the system it has been managed by another team and this was the first time i had looked at it. I thought i'd share my thought process to identifying... Read More...

by ACALVETT | with no comments

Filed under: SQL 2000, Tips, Performance