Tuesday, June 26, 2012

Index talk for ISUG on June 27th

Go to ISUG.com and register... tomorrow is my webinar on indexing.

*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.*

No comments:

Post a Comment