Yes, I know that statistics are independent of indexes... but think of stats as automatically generated indexes...

Can't believe that MS recommended turning them off... Look's like I have a little...

WHERE ','+@strApplicationIDs+',' LIKE '%,'+CAST(ApplicationID AS VARCHAR(10)+',%'

Index usage is certainly not possible using this method...

Hmmm... anyone know of any disadvantages of specifying VARCHAR(MAX) for everywhere a varchar is needed?

I think we've pretty much beat the subject of when and when not to use NOLOCK to death and the author pretty much summed up all that in his new...

Make sure TempDB is set to "simple" recovery mode... kill the developers that wrote cursors, views of views, and monster CTE's.  

What is that requirement?  Why does this need to be done?

...was thinking of large tables, which would make sense to turn off auto update statistics...

WHY?

Oooo, ... you've implimented this as correlated subqueries in the SELECT list... not what I had in mind at all... I gotta think about this a bit but I was...

Heh... yeah, I've been burned by the throw-away timeout on this forum many a time at first... I've learned to always [Ctrl-a][Ctrl-c] before I even think of hitting [Post Reply]......

Um, you need to go back and read the code, Ken...  I'm not really relying on "Physical" implimentation at all and you should never try this on a "column without an...

> have a table with just the mile_codes in it and tried tying that in but can't seem to get it to work.

Do an outer join to that table...

Kenneth, you...

>"WOW!"  This is pretty cool. Not only does it work great, but is giving me some more...

Heh... yeah... the site has a "timeout" for some reason... you should always copy the entire body of your post before you hit [Post Reply] so you don't loose anything.

The...

LMtz,

Any of this helping of do you need another "track"?