Next Meeting

Date Wednesday, June 1, 2016, 6:00 PM - 8:00 PM

Speaker Paul Randal (Remote)

Topic: Index Fragmentation: Internals, Analysis, and Solutions

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. 

Sponsor:

Kforce
RSVP:

If you plan to attend, please RSVP on Meetup.  Please join the Meetup group if you are not yet a member.  Your Meetup RSVP helps us plan food for the meeting.

Welcome

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most sessions will have a presentation; however, throughout the year we schedule a few group sessions designed to provide a forum that allows attendees to discuss real-world SQL Server related questions, issues and concerns which are addressed 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


New Meeting Location:

We have a new meeting location as of October 2013:

Patrick Hays Learning Center
2700 Gateway Oaks Drive
Suite 2600
Sacramento, CA 95833

Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600.


View Larger Map

 

Announcements

SQLSaturday Sacramento 2016 (SQLSaturday #540, #sqlsatsac):
SQLSaturday Sacramento 2016 (SQLSaturday #540) is July 23, 2016.
Attendee, speaker and sponsor registration is now open.
http://www.sqlsaturday.com/540/EventHome.aspx

PASS Summit 2016 Registration Discount Code:
Save $150 with the SACSQLUG registration discount code LC15QXQ4 for PASS Summit 2016

SQLSaturday #399: SQLSaturday 399 was held on July 25, 2015
http://www.sqlsaturday.com/399/EventHome.aspx

SQLSaturday #312: SQLSaturday 312 was held on July 12, 2014
http://sac.sqlpass.org/SQLSaturday/SQLSaturday312.aspx

PASS Summit 2013: Watch the Keynotes, select sessions, interviews and more from PASS Summit 2013 at the PASStv site: http://www.sqlpass.org/summit/2013/PASStv.aspx

SACSQLUG Meeting Archive: Our meeting archive pages have been revised:
http://sac.sqlpass.org/MeetingArchive.aspx

24 Hours of PASS: The Summer 2013 24 Hours of PASS session recordings are now available for viewing:
http://www.sqlpass.org/summit/2013/Sessions/SneakPeeks.aspx

SQLSaturday #222: Our second annual Sacramento SQLSaturday was held on July 27, 2013; more info, pictures, blog and tweet links:
http://sac.sqlpass.org/SQLSaturday/SQLSaturday222.aspx

Sorry, there are no upcoming meetings. Please check back for updates.