Databases

Benefits of Primary Keys in Database Tables

by

Hi friends! This article, discusses about the benefits of primary keys in database tables. A primary key is a special column (or set of combined columns) in a relational database table, that is used to uniquely identify each record. A database primary key cannot contain NULL values and each table can have only one primary … Read more

How to Rebuild All Indexes Online for a SQL Server Database

by

This article, discusses about, how you can rebuild all indexes online for a SQL Server database and provides useful T-SQL scripts that can help you perform this task. The below script makes use of the undocumented SQL Server stored procedure “sp_MSforeachtable” and with the proper syntax, it rebuilds all SQL Server indexes online for all … Read more