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...
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...
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...
Not sure what you mean by recompiling the table, and this particular query that i'm testing is not a stored proc...it's being run in a QA window....
Thanks for the suggestion, m.<br /><br />I changed my covering indexes on Assessment as follows (dropped existing indexes as necessary):<br /><br...
Gotcha. I do see the seek on the b table, which is the only table used in the where clause. What should I do to make the a table use a seek, if the...
What am I missing here? I have a covering index on the Assessment table:<br /><br />CREATE INDEX [IX_Covering_2] ON [dbo].[Assessment]...
I'm using DTS to copy the tables because I'm not sure how I would tell Veritas to start restoring the nightly full db backup immediately after it's...
Thank you all for your replies and great suggestions. I really appreciate it.<br /><br />A few clarifications...<br /><br />The DTS package copies...
Thanks for the reply! I forgot to mention one piece of the puzzle that might make it easier for you to offer suggestions. This particular screen...
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)...
Separate names with a comma.
