data-konzept

'You need to know SQL Server basics to keep database performance at the highest level. This knowledge will also help you to be prepared to any potential problems. When working with files, you may discover that there is not enough free space to store the required data in the file. By default, in such situations, SQL Server locks the file and extends it (it’s called – autogrow).'...

http://blog.sqlauthority.com/2015/12/14/sql-server-fix-sql-server-index-fragmentation-with-dbforge-index-manager/