http://www.sqlservercentral.com/Articles tagged SQL Server 2005, Performance Tuning and Scaling, Performance Tuning posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system. http://www.sqlservercentral.com/articles/Performance+Tuning/2764/2007/12/17http://www.sqlservercentral.com/articles/Performance+Tuning/2764/Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system. http://www.sqlservercentral.com/articles/Performance+Tuning/2764/2007/12/17http://www.sqlservercentral.com/articles/Performance+Tuning/2764/A series of tips on optimizing XML in your SQL Server databases. http://www.sqlservercentral.com/redirect/articles/2869/2007/02/21http://www.sqlservercentral.com/redirect/articles/2869/Using hints in a query is something that most DBAs don't ever seem to bother with, but when they do, NOLOCK seems to be their hint of choice. Wayne Fillis brings us a detailed examination of how this particular hint actually affects the performance of your system. http://www.sqlservercentral.com/articles/Performance+Tuning/2764/2007/12/17http://www.sqlservercentral.com/articles/Performance+Tuning/2764/Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting. http://www.sqlservercentral.com/articles/Performance+Tuning/2677/2006/10/30http://www.sqlservercentral.com/articles/Performance+Tuning/2677/Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting. http://www.sqlservercentral.com/articles/Performance+Tuning/2639/2006/10/04http://www.sqlservercentral.com/articles/Performance+Tuning/2639/Performance Tuning can be as much an art as a science when working with SQL Server, but there are many fine techniques that can help you get started. New author Michael Morin brings a great new technique helping you get started on determining where the heavy I/O users are in your database. http://www.sqlservercentral.com/articles/Performance+Tuning/2573/2006/08/30http://www.sqlservercentral.com/articles/Performance+Tuning/2573/