Rebuild Indexes of database with fragmentation more than 30%

Rebuild of indexes is the prime job of a DBA as heavily fragmented indexes can degrade query performance and cause your application...

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

When I right click on the database diagrams folder in SSMS to create new diagram. Following popup window open with error.

Solutions:
From the Message you can clearly see that the...

Attach Database “Operating System Error 5 (Access is denied)” MSSQL Server 2012.

When I try to attach mdf file I got following error below.

Solution:

There are multiple solutions to this

1    1.    Move .mdf and .ldf to SQLServer install directory Data folder...

Create Database Error "operating system error 112(There is not enough space on the disk.)"

I try to create database by generating script of another database, which was a huge Database. When I run the script below

USE [master]

GO

CREATE DATABASE [YourDB] ON  PRIMARY

( NAME...