Avoiding Dynamic SQL

I did some googling in response to a question posed to me regarding alternatives to using dynamic sql when performing custom search functionality.
 
I found the following posts:
 
Steve Eichert’sOptional Parameters in SQL Server Search Queries (read the comments too… some gems on execution plan and indexing to improve performance in there as well)
 
 
Advertisements

One thought on “Avoiding Dynamic SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s