Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nnkumar

    Procedure Cache and I/O Statistics

    In SQL Server 2000- 1. Is there any way to see the Execution Plans cached in Procedure Cache? 2. In what way I/O statistics (from QA) and trace's I/O cost (from Profiler) differs? Need your help, Thanks!
  2. nnkumar

    Hint for Table Scan

    For tables with no Clustered index, hint INDEX(0) will force a table scan. But, I query a table with Clustered index. Is there any hint to force the optimizer to do a Table scan? I am using SQL Server 2000. Thanks in Advance.

Part and Inventory Search

Back
Top