Browse by Tags

Disk Space Requirements for Index DDL Operations

Published 28 September 7 8:38 AM | SSQA.net

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...

Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing

FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005

Published 2 August 7 9:17 AM | SSQA.net

There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may...

Filed under: performance, backup, optimization, disk space, full-text