SQL Server Performance

Search Results

Search Again
  1. Expansion

    Query plan over multiple databases

    Thread by: Expansion, Apr 1, 2010, 1 replies, in forum: Performance Tuning for DBAs
    My query spans three databases on one Sql Server 2000 instance. Is the query execution plan optimized as it would be when the tables are all in the...
  2. Expansion

    Performance tip 'Optimizing SQL Server Clustered Indexes' true?

    Thread by: Expansion, Jul 15, 2008, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Is the following performance tip in the Newsletter from 14-07-2008 true? I don't think so. Optimizing SQL Server Clustered Indexes If you run into a...
  3. Expansion

    Query cost in Query Analyzer

    Thread by: Expansion, Aug 12, 2003, 5 replies, in forum: Performance Tuning for DBAs
    After I moved to Sql Server 2000 (local), I see often in the execution plan cost of more then 100 % (for instance with nested loop join). The query...
Showing results 1 to 3 of 3
Search Again