I have an index file group that is filling up a disk drive. The fill factor is set to 80%. I also have a job that rebuilds these indexes when the fragmentation gets beyond a certain percentage. I want to change the fill factor so the index size will decrease. Is this something that can be done without having to drop and recreate the entire index?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…