Create Database Snapshot

CREATE DATABASE statement can also be used to create database snapshots of existing databases. Database snapshot is a read only static view ...

Create Database in SQL Server 2012

  This example query create table named as db_name  in this case I omitted PRIMARY option and the first file is assumed as a primary file.T...

Policies Management In SQL Server

New SQL Server versions upgrade with new Declarative Management Framework ( DMF ) which policy based system managing one or more server ins...

Introdiuction to Query Optimizer

     In Practical case most of the DBE's can not find the query that optimized execution process of the query.           The question th...

Requirements for Database Security

Ever since, men had learned and concentrated on ways on how they could protect their files and documents even before computers ever existed...