Pittsburgh SQL Server Users Group

EventDisplay

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
UTC : Tue, Feb 23 2016 22:00 - 00:00
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’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and has been a SQL Server MVP ever since. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp. Full bio at http://www.sqlskills.com/about/paul-s-randal/

Attachments

            

Thank you to our Sponsors!

PASSChapterLogo100.jpg

sql_micro_sm.gif

 

   

   

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids