Next Meeting: Tue, Feb 23 2016

Index Fragmentation: Internals, Analysis, and Solutions

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://www.meetup.com/PittsburghSQL/events/228383640/

.Sponsor: TeleTracking

When

iCal
Event Time : Tue, Feb 23 2016 17:00 - 19:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Feb 23 2016 22:00 - 00:00

Where

Pittsburgh Technology Council
Pittsburgh, Pennsylvania

Direction: None

Featured Presentation

Index Fragmentation: Internals, Analysis, and Solutions

Speaker: Paul Randal, CEO and Owner SQLskills.com

Summary: As soon as you have more than one index on a table, you're going to start seeing fragmentation. Many people know that this fragmentation is bad, but why is it bad? And what is the best way to get rid of it? Come find out from the person who wrote the tools for detecting and removing index fragmentation. In this session, you’ll learn how fragmentation occurs and why the process that leads to it can often be as damaging to performance as the fragmentation itself. You'll also learn how to test for fragmentation, the different methods of removing it, and everything you need to consider when putting together an appropriate fragmentation-management strategy.

About Paul: Paul Randal is the CEO and co-owner (with his wife, Kimberly Tripp) of SQLskills.com, a world-renowned training and consulting company. He worked on the SQL Server team for 9 years, most notably rewriting DBCC CHECKDB, and since then has been a SQL Server MVP and Microsoft Regional Director. Paul is an accomplished writer and presenter, with numerous books, articles, whitepapers, and conference top-speaker awards over the years. You can read more about Paul at www.SQLskills.com/about/paul-s-rand

Attachments

Membership is available at no cost and is open to employees of all size companies, including technical experts, novice users, Microsoft partners and Microsoft employees.
 
Member Benefits:
·         Exposure to best practices and technical expertise 
·         Networking with peers
·         Opportunity to improve knowledge and skills
·         Discussion forums
·         Technology updates
·         Book reviews
·         Discounts

·         Technical resource center

For instructions on how to join, please click here.

The Pittsburgh SQL Server User Group (PSSUG) was established to provide a forum for exchanging information, ideas and expertise on SQL Server and related products. The mission of PSSUG is to further the use of the SQL technology platform and products in southwestern Pennsylvania by providing local support, peer networking opportunities and educational events for IT professionals utilizing these technologies.  And to have fun!!

 PSSUG – Call for Volunteers!

The PSSUG leadership seeks those who want to assist with the planning and implementing of the monthly meetings. In addition, we need presenters!  New speakers are encouraged to apply.  If you are interested in helping or have additional thoughts and ideas, please contact pittsburgh@sqlpass.org.