  Hi From MUGH and SQLCON we would like to thank all who participated in the yesterday discussion.  Am attaching few links which where part of our discussion and other helpful links that could be useful for performance tuning.  Join Hints urlLink http: www. mssqlcity. com/
Articles/ General/ NestLoop. htm urlLink http: www. mssqlcity.
com/ Articles/ General/ HashJoins. htm urlLink http: www.
mssqlcity. com/ Articles/ General/ mergeJoins. htm Other helpful links ·
 Inside SQL Server 2000/ 7. 0 by Kalen Delaney,  urlLink http: www. insidesqlserver.
com ·  The Guru's Guide to Transact- SQL,  urlLink http: www. khen.
com/ books. htm ·  SQL Server Performance and Scalability References,  urlLink http: www.
microsoft. com/ sql/ evaluation/ compare/ performance.
asp ·  Understanding Performance Testing,  urlLink http: msdn. microsoft. com/
library/ techart/ d5dplyover. htm ·  224587 INF:  Troubleshooting Application Performance with SQL Server urlLink http:
support. microsoft. com/ id= 224587 ·  243586 INF:
 Troubleshooting Stored Procedure Recompilation urlLink http: support. microsoft. com/ id= 243586 ·
 298475 INF:  Information Required to Successfully Troubleshoot Application http: support. microsoft. com/ id=
298475 ·  175658 How To Gather Information for Effective Troubleshooting of Performance http: support. microsoft. com/ id=
175658 ·  319942 HOW TO:  Determine Proper SQL Server Configuration Settings http: support. microsoft. com/
id= 319942 ·  297864 INF:  Performance Considerations for an Upgrade from SQL Server 6. 5 http: support.
microsoft. com/ id= 297864 ·  314648 INF:  Differences in STATISTICS IO,
 SQL Profiler and Sysprocesses IO http: support. microsoft. com/ id= 314648 ·
 311826 INF:  Index Tuning Wizard Best Practices http: support. microsoft. com/ id=
311826 ·  Index Tuning Wizard 2000,  http: msdn. microsoft. com/
library/ techart/ itwforsql. htm ·  Index Tuning Wizard 7. 0,
 http: msdn. microsoft. com/ library/ techart/
msdn_sqlindex. htm ·  Troubleshooting the Index Tuning Wizard,  http: msdn. microsoft.
com/ library/ psdk/ sql/ tr_servtools_48ro. htm ·
 195565 INF:  How SQL Server 7. 0 and SQL Server 2000 Autostats Work http: support. microsoft. com/
id= 195565 ·  197297 INF:  Comparison of Join Techniques http: support. microsoft.
com/ id= 197297 ·  139609 PerfMon:  High Number of Pages/ Sec Not Necessarily Low Memory http:
support. microsoft. com/ id= 139609 ·  268343 Umdhtools.
exe:  How to Use Umdh. exe to Find Memory Leaks http: support. microsoft. com/
id= 268343 ·  286350 HOWTO:  Use Autodump+  to Troubleshoot " Hangs"
 and " Crashes"  http: support. microsoft. com/
id= 286350 ·  316365 INFO:  ROADMAP for How to Use the . NET Performance Counters http: support.
microsoft. com/ id= 316365 ·  150934 How to Create a Performance Monitor Log for NT Troubleshooting http: support.
microsoft. com/ id= 150934 ·  130926 Using Performance Monitor to Identify a Pool Leak http: support.
microsoft. com/ id= 130926 ·  146005 Optimizing Windows NT for Performance http: support.
microsoft. com/ id= 146005 ·  248345 How to Create a Log Using System Monitor in Windows 2000 http: support.
microsoft. com/ id= 248345 ·  275685 INF:  Importing Performance Monitor Logs into SQL Server http:
support. microsoft. com/ id= 275685 Regards,  Viswanath MUGH Home Page urlLink http:
www. mugh. net SQLCON urlLink http: www. mugh. net/
sql 
