From a real project: conventional backup and restore, split file backup when a disk runs short of space, mirror file backup, and the FORMAT clause.
SQL SERVER – Automated Index Defragmentation Script
Fragmentation from inserts, updates and deletes slows tables down. For index defragmentation I use the automated script by my friend Michelle Ufford (SQLFool).
SQLAuthority News – Launch of Gandhinagar SQL Server User Group
The launch of Gandhinagar SQL Server User Group on March 27, 2009 drew over 50 database enthusiasts, and we even ran out of chairs. Register at the portal.
What Is a Database Backup? Full, Differential, Log
A database backup comes in three kinds and they work together. Measured sizes for full, differential and log, why the recovery model decides everything, and the restore order that cannot be improvised.
SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column
Deleted rows left a gap in an identity column for my developer. Here is how to reseed identity of a table so new rows keep the sequence without gaps.
SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense
IntelliSense in SQL Server 2008 not showing suggestions? Four ways to Enable IntelliSense, starting with connecting to a 2008 instance and checking Tools, Options.
Planning for Data Growth
Planning for data growth uses backup and file trends, workload events, storage lead times, and a dated request for more capacity.