SQL 2005: Advanced Indexing Strategies

SQL 2005: Advanced Indexing Strategies

In this session we look at a fast-paced collection of indexing tips and tricks based on an already optimized base table structure. How you create your base table – as well as cluster it – has a big impact on that table’s performance.

Once the base table structures have been defined and you have to further improve system performance, where do you look and how do you do this? In this session we will talk about targeting both the known and finding the unknown performance problems. Once you know where the problems are we’ll go through numerous options to improve the performance using indexes.

Presenters

Adam Cogan

  Adam Cogan is the Chief Architect at SSW, a Microsoft Certified Partner specializing in Office and .NET Solutions. At SSW, Adam has been developing custom solutions for businesses across a range of industries such as Government, banking, insurance and manufacturing since 1990 for clients such as Microsoft, Quicken, and the Fisheries Research and Development Corporation.
Adam runs the Microsoft .NET User Group in Sydney and the software house SSW (http://www.ssw.com.au). Adam is a tireless advocate of MS technologies and speaks regularly at User Groups, Universities and at TechEd in the USA, NZ and Australia. Adam is the chair of the Speaker Bureau of the APAC INETA organization and is actively involved in the regional INETA management process. More recently Adam has been working on the SQL Reporting Services whitepapers for the SQL Server Team.

Time

Sat. 3pm

Very amusing.

 
Highlights:
  1. "Would you index on Customer.State?" asks Adam.  "Not in NZ" answers James.
  2. Covering indexes (index on all the fields in the SELECT statement) is optimisation of last resort.
  3. "SS Management Studio doesn’t remember which database I was in?  That’s reason enough to uninstall the entire thing."
  4. Index on the Foreign keys. 
  5. Use the SSW SQL Auditor from SSW

 

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