Fragmentation in SQL Server
2. External Fragmentation
Internal Fragmentation:- In this fragmentation, there exists a space between the different records within a page. This is caused due to the Insert, delete or Update process and due to this Index takes more space than it needs to and it result in more read operation during scanning. It can also be caused due to the low value of fill factor of the page which determine how much % of the page should be used for storing the records.
External Fragmentation:- In this fragmentation, the extents of the table is not physically stored continuously on the disk which causes the jump from one extent to another extent which takes longer time.
Both the fragmentation can be resolved by Rebuilding or Reorganization of the indexes of the tables.
For Rebuilding or Reorganization of the indexes , please refers the below link:
http://vivekjohari.blogspot.in/2013/01/rebuild-and-reorganization-of-indexes.html
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
RTRIM() function in SQL Server
Difference between Primary key and Unique key
Merge Command In Sql Server
About The Author
vivekjohari
I am currently working as a Senior Database Professional and have around 18 years of experience in database. Degree:- Master Degree in Computer(MCA) Certification course in Data Science & Machine Learning from Indian Institute of Technology (IIT), Delhi Work experience:- Designing of the database. Database Optimization. Writing Complex Stored Procedures,Functions,Triggers etc. Designing and developing SSIS & DTS packages. Designing SQL Reports using SSRS. Database Server Maintenance. Certification:- MCTS: DA-100: Analysing Data with Microsoft Power BI MCTS: DP-300: Administering Relational Databases on Microsoft Azure Microsoft certified Sql DBA in Sql server 2008 (MCTS). Microsoft certified BI professional in Sql server 2008 (MCTS). Oracle certified profession DBA in ORACLE 10g (OCP) certified profession DBA in ORACLE 9i (OCP) My other publication Technical Blog:- Technologies with Vivek Johari Guest Author and Blogger at sqlservercentral.com
Thanks Vijila for your valuable comments
Hi vivek any openings for SQL DBA