SQL Server Performance

Search Results

Search Again
  1. lingprof

    Forcing a clustered index SEEK

    Thread by: lingprof, Feb 9, 2007, 5 replies, in forum: SQL Server 2005 General DBA Questions
    This is related to a previous thread http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18926). I thought the problem was solved, but...
  2. lingprof

    Forcing Index Scan > Index Seek

    Thread by: lingprof, Jan 16, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions
    Sorry, this may be akin to a FAQ, but ... In the Query Execution Plan, I see that SQL Server is going to do a Clustered Index Seek when a high...
  3. lingprof

    Is it the hard drives, or 2005 vs 2000 ??

    Thread by: lingprof, Jan 15, 2007, 15 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    This is kind of a follow-on to a query I posted a couple of weeks ago, with some additional info that I've gotten in the meantime. It's getting more...
  4. lingprof

    2005 index much slower than 2000 (??)

    Thread by: lingprof, Jan 1, 2007, 6 replies, in forum: SQL Server 2005 General DBA Questions
    I have an identical database (with identical indexes) on two different machines. The hardware for both machines is similar, and both are running...
Showing results 1 to 4 of 4
Search Again