SQL Server Performance

Search Results

Search Again
  1. bobogs

    ISNULL() vs. (x = y or x is null)...index scan/see

    Thread by: bobogs, Jun 27, 2007, 2 replies, in forum: T-SQL Performance Tuning for Developers
    Why would ISNULL(x, y) use an index scan, but (x = y OR x is null) use an available covering index? The covering index is not used at all when...
  2. bobogs

    Google-like single textbox search functionality

    Thread by: bobogs, Aug 3, 2006, 1 replies, in forum: General Developer Questions
    We currently have an "Inquiry" form in our VB6 app that presents the users with many textboxes, comboboxes and listboxes which can be used to build a...
  3. bobogs

    views with joins - how do they work/perform?

    Thread by: bobogs, Sep 23, 2005, 1 replies, in forum: General DBA Questions
    If I have a view (vwTest) defined as:<br /><br />select a.fld2a as fOne, b.fld2b as fTwo from table1 a inner join table2 b on a.fld1 = b.fld1<br...
  4. bobogs

    index scan with covering index

    Thread by: bobogs, Sep 19, 2005, 7 replies, in forum: Performance Tuning for DBAs
    What am I missing here? I have a covering index on the Assessment table:<br /><br />CREATE INDEX [IX_Covering_2] ON [dbo].[Assessment]...
  5. bobogs

    covering index(es) for joined tables

    Thread by: bobogs, Sep 15, 2005, 13 replies, in forum: Performance Tuning for DBAs
    I have an Inquiry screen in my app that lets the user set various filters then run the query. I'm seeing good query performance (all index seeks)...
Showing results 1 to 5 of 5
Search Again