4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

FILLFACTOR-Pro and Con

The audience will see benefits and disbenefits of usage of FILLFACTOR in different scenarios. The audience will see what deep impact a wrong usage of FILLFACTOR may have to their applications in the same way as the speed up for different workloads if a FILLFACTOR will be chosen for the objects in the database.

We will do a deep dive into the dependencies of indexes and buffer pool and locate impacts of bad indexes and wrong usage of FILLFACTOR to the buffer pool.

This session is a demo driven presentation (75%)
Presented by Uwe Ricken at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Uwe_Ricken.jpg
    Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of membership administration software for the American Chamber of Commerce in Germany. Afterwards the software has been distributed to five additional European countries. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for the Deutsche Bank AG in Frankfurt am Main. After 6 years of experiences in the European Operations Center as a DBA and over 14 years as a developer of complex database models he earned in May 2013 the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification from Microsoft. The successful year 2013 has been finalized with the first MVP award for his outstanding support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken was the first MCM + MVP in Germany! To provide his deep knowledge about Microsoft SQL Server to the interested community Uwe is blogging since 2010 at http://db-berater.blogspot.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German speaking SQL community a deeper inside view into the technology of Microsoft SQL Server. Uwe Ricken is a speaker on many international conferences and events and preferred topics for “Database Internals”, “Indexing” and “Development”.
    http://db-berater.blogspot.de
  • Video
    The video is not available to view online.