system databases – Igor Micev

Indexes optimize for the system databases

Posted on December 23, 2016 by Igor Micev — No Comments ↓

Maintenance of the system databases in SQL Server regarding the indexes is important. The system tables also have indexes and their maintenance is of asset on the busy environments. It’s also important to know that the indexes in msdb and Continue reading Indexes optimize for the system databases→

Rebuilding the system databases

Posted on March 2, 2016 by Igor Micev — No Comments ↓

The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is the same – https://msdn.microsoft.com/en-us/library/dd207003.aspx. When you install a SQL Server instance you should check the collation for the instance which you Continue reading Rebuilding the system databases→