Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.  Read more...

This is a data quality script that locates unused Database Roles for maintenance purposes  Read more...

Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.  Read more...

How to set the database to a single user mode  Read more...

Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.  Read more...

Auto compression of index, if index includes > 1 million rows.  Read more...

Script to move physical files to a new location  Read more...

Reports on physical size of tables in your database to identify largest.  Read more...

Using this script you can create a list of sql commands for foreign keys manipulation.  Read more...

Index maintenance procedure using rebuild or reorganized based on fragementation level.  Read more...

This script lets you to know how much disk space will be left after the next database grow taking in account the free space left in the database.   Read more...

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.  Read more...

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.   Read more...

I have a database which has several tables that have very heavy write operations. These table are very large and some are over a hundred gigabytes. I noticed performance of this database is getting slower and after some investigation we suspect that the Auto Update Statistics function is causing a performance degradation.  Read more...

This script will allow reindexing (either rebuild or reorg)  Read more...

This view reports almost everything you want to know about your indexes  Read more...

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...

In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?   Read more...