*Everything You Wanted to Know About Indexing for Performance.*
Wednesday, June 27th, 1pm-2:30pm.
*Please note that this is a 90 minute session.*
*Synopsis*
This session will cover everything you want to know about indexes but
didn’t know who to ask. Topics include:
- Differences between clustered & nonclustered indexes, and why you’d
choose one over the other
- Why the optimizer will or won’t select an index
- The difference between an index and a key
- Using and abusing search arguments (SARGs)
- Index covering
- Forcing index selection (and why you don’t’ want to)
- Partition support (time permitting)
Register now: http://my.isug.com/e/in?eid=145
*About the Speaker*
Jeff’s background includes a B.S. Degree from Rensselaer Polytechnic
Institute, and work experience from PC's to Mainframes and back again. Jeff
has many years of client/server, Sybase, and Microsoft SQL Server
experience, with a special emphasis on assisting clients in migrating from
existing systems to pilot and large-scale projects with very large
databases. He is very well known in the industry, having spoken at user
conferences and user groups for many years, written articles and columns
for many magazines nationally and internationally, as well as having
written over a dozen books. Recently his focus has been on database
performance, tuning, monitoring, and reengineering. Jeff has been in
consulting, training, and the software businesses for over 2 decades. He
has a demonstrated talent for staying at the leading edge of technology, as
well as transferring his knowledge to others.
*Note that attendance is free for Basic, Green or Gold members only.
Non-members and associate members must either join/upgrade, or pay a small
fee to attend. To help make this decision easier for you, in August Jeff
will be back with a second session on query joins. We anticipate Jeff
presenting every couple of months or so after that, so now is a great time
to become a full member.*
