SQL and the like : Catch All Querieshttp://sqlblogcasts.com/blogs/sqlandthelike/archive/tags/Catch+All+Queries/default.aspxTags: Catch All QueriesenCommunityServer 2007.1 (Build: 20917.1142)Catch all queries and indexinghttp://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/catch-all-queries-and-indexing.aspxThu, 27 Aug 2009 07:21:02 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12252SQL and the like0http://sqlblogcasts.com/blogs/sqlandthelike/rsscomments.aspx?PostID=12252http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/catch-all-queries-and-indexing.aspx#commentsAmongst many others, Gail Shaw has blogged on the subject of catch all queries . On many occasions I have needed to do something similar and found performance to be pretty dire on large tables. Typically I would use dynamic SQL to generate the query but...(<a href="http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/catch-all-queries-and-indexing.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12252" width="1" height="1">TSQLSQLServerPedia SyndicationQuery PlanCatch All QueriesOptimizer