SQL Server Performance

Search Results

Search Again
  1. dbland07666

    Update clustered index value?

    Thread by: dbland07666, Sep 24, 2007, 3 replies, in forum: General DBA Questions
    I'm trying to make sense out of this statement: When selecting a column to base your clustered index on, try to avoid columns that are frequently...
  2. dbland07666

    NOT EXISTS vs NOT IN vs LEFT OUTER JOIN

    Thread by: dbland07666, Jul 26, 2007, 8 replies, in forum: T-SQL Performance Tuning for Developers
    I'm having a debate with someone over which is more performant and I see that athttp://www.sql-server-performance.com/transact_sql.asp you favor NOT...
  3. dbland07666

    Run 2 update stats on big tables at same time?

    Thread by: dbland07666, Apr 18, 2007, 4 replies, in forum: General DBA Questions
    We have a large sql server 2000 db (over 90gb) with a couple of large tables (over 30gb each. In all, update statistics takes 11 hours. Do you know...
Showing results 1 to 3 of 3
Search Again