Chat on SQL Server Performance
Recently held an MSDN India Chat on SQL Server 2000 Performance and Internals with fellow MVP Vinod Kumar. The chat session focused on some tips and tricks that people can follow in their applications to ensure that SQL Server performs at its best. The session was well received and we had some interesting questions on peformance. From the session it felt that lot of people use Dynamic SQL based implementations to provide search features in their web-sites and this is an area of concern when it comes to performance management. There is an excellent article from Erland (SQL MVP) on how to manage and construct dynamic queries and its an excellent read. You can find the article
here.