i am however a little dissappointed at the article. i mean its a bit short and uninformative. ive only been on this site a few months now, but i think...

indexed views have lots of drawbacks (i.e no left joins, subqueries etc etc) but in a highly normalised setup they are priceless when used correctly, and can solve some real...

use fulltext search. its fast, its adaptable and its simple

i would also add that teaching the benefit of using good mathematical principals, you should pick a better example query... not one that is at best teaching people how to...

yes but its not as flexible ie doing something like:

select * from table where (@date is null or [datecol] < @date)

either way though, for best performance with this type of...

Bad for performance in general is my experience with using this type of sequence, even in some smaller tables and particularly when i used alot of parameters with this same...