Midlands PASS February 2016 Meeting

Midlands PASS has changed its meetings from the 2nd Thursday to the 2nd Tuesday of each month. This takes effect with this month’s meeting. We are still meeting at the same location in West Columbia, SC. However, the name of the organization has changed: Microstaff IT has become We Know IT!

For this month’s meeting on February 9th we are looking at improving queries. Here’s the abstract:

We want queries to run fast. The faster queries run, the less likely they are to get in the way of other queries (blocking). The faster queries run, the less likely they are to collide where one will have to be rolled back (deadlocking). And the faster queries run, the more queries we can pump through the system, thereby improving performance. In this presentation we’ll look at how the SQL Server query engine works: how it breaks down a query, how it uses indexes, and how it puts all this together to produce an execution plan. By understanding how the engine works, we’ll understand how to improve our queries.

If you can make it out, please RSVP so we’ll know how many refreshments to bring.

Advertisements

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: