This repository provides simple, ready-to-use scripts for maintaining your Windows Server and Microsoft SQL Server environment. It is designed for IT staff or power users who want to perform essential ...

SQL Server database corruption is troublesome for DBAs, particularly if the situation arrives suddenly and there is no backup. This situation can lead to prolonged downtime and permanent data loss in ...

Do you have a large data import that leaves your indexes less than perfect? Do you want to backup your current database before you run a purge package? You are in luck; SSIS contains a handful of ...

Maintaining and updating the businesses database is crucial to running a successful company. To prevent and diagnose availability, health, and performance issues it is essential to review and manage ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes data ...