Dynamic code for efficient searching

Ian Meade presents “Dynamic code for efficient searching” to the SQL Server Ireland User Group this September.

When:                 September 4th,  2012 at 18.30

Where:                Microsoft Atrium, Carmanhall Road, Sandyford, Dublin 18

Cost:                    FREE Community Event

Registration is at http://www.mtug.ie/UserGroups/SQLServer/tabid/82/ctl/Details/Mid/413/ItemID/103/Default.aspx?ContainerSrc=[G]Containers/_default/No+Container

Ian will illustrate how multipurpose queries can lead to issues with scalability and performance. He will show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then he works through building a dynamic search query to resolve the identified performance issues.
He touches on:
• Testing.
• Tuning each part of the query in isolation.
• Plan cache re-use
• Security – SQL injection attacks and authorisation / code signing.
• Possibly, mentioning greater re-use and extendibility.

Target audience:

Developers and DBA trying to resolve performance issues found when moving to medium or larger sized data sets.


Ian Meade has been working with SQL Server since 2001 and with a database / application developer for even longer. Lots of experience designing and implementing db solutions as well as fixing sick solutions. Holder of MCM SQL Server 2008, MCSD.NET and other certifications. Likes cheese.

Leave a comment

1 Comment

  1. this subject makes me think of other things that happens to us every day, it makes me reflect a lot.http://www.opcons.com


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

%d bloggers like this: