Sacramento SQL Server User Group

Next Meeting

Wednesday,

June

01

Index Fragmentation: Internals, Analysis, and Solutions - Paul Randal (Remote)

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

In this remote presentation, Paul Randal discusses Index Fragmentation: Internals, Analysis, and Solutions. 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. Paul S. Randal, SQLskills.com CEO / Owner, is a Microsoft SQL Server MVP and a Microsoft Regional Director. 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 is a world-renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR. 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. Email: Paul@SQLskills.com Website: http://www.SQLskills.com Full Bio: http://www.sqlskills.com/about/paul-s-randal/ Blog: http://www.SQLskills.com/blogs/Paul Twitter: http://twitter.com/PaulRandal SQL Server MVP since 2008

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Announcements

SQLSaturday Sacramento 2017 (SQLSaturday #650, #sqlsatsac):
SQLSaturday Sacramento 2017 (SQLSaturday #650) was July 15, 2017.
http://www.sqlsaturday.com/650/EventHome.aspx

Our Sponsors

PASSChapterLogo100.jpg

 

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