Wednesday, December 12, 2018
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
Indexing: best practices & new SQL 2005 features
Author: Rob Farley Date Posted: 11/1/2005 10:19:05 AM
This month we have Greg Linwood coming to speak to us about indices, or indexes, or indeci, oh you know what I mean. And I'll be giving away a really nice shirt, and an MSDN key-ring. Heaps of reasons to come along!

While many indexing best practices continue from SQL Server 2000, there are some new indexing features in SQL Server 2005 which you should be aware of. In this session, we first discuss how to design efficient and maintainable clustered and non-clustered indexes before drilling into the importance of query tuning with non-clustered covering indexes. In the remainder of the session, we'll discuss SQL Server 2005's new indexing options including Online indexing, Included Columns, Index Management Views and Disabled Indexes. If you want to learn how to design optimal table structures, achieve better data availability as well as indexing for performance, this is a session for you.

Greg Linwood has worked with SQL Server since 1993 and received Microsoft’s SQL Server MVP award in 2003. Greg is the Australian Director of "Solid Quality Learning" - the world's leading provider of expert SQL Server training and is also Managing Director of "SQL Servants" - a dedicated Australian SQL Server infrastructure support business. Greg has worked in a range of developer & DBA capacities throughout his career and has gained significant expertise in SQL Server tuning & optimisation techniques. He is passionate about building high quality SQL Server community events in Australia and is a founder of the Australian SQL Server User Group. Greg lives in Melbourne with his fiance & two cats. He is a keen pianist & a demon at mini ping pong.

Advance notice: On Dec 15th, David Lean will be joining us to speak on either Report Builder, SQL Broker or the Query Optimizer. If you want to help choose which one it'll be, come along to this meeting!

ADNUG Plug: Wed 9th Nov, Carl Jongsma – What You Don't Know Can Hurt You - 5.45pm at SA Innovation Centre, L2 Santos House

Venue: SA Innovation Centre, L2 Santos House | Duration 12:00-14:00 | On: Thursday, November 10, 2005