SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2014

SQL Server - Clustered Indexes and Non Clustered Indexes

To understand the concept of Clustered and Non Clustered indexes, it is important to understand the definition and functionalities of indexes first. An Index is a structure related to a view or table that speeds up the processes by quick retrieval of integrated rows from view or table.

There are…

Read more

1 comments, 1,756 reads

Posted in on 28 November 2014

SQL Server Disaster Recovery Planning

While administrating SQL Server database, one of the important part is to prepare a plan to work against potential disasters. A tried-and-tested design for backup and restore plays a major role in recovering database post disaster. However, some additional measures are to taken to ensure that system and database are…

Read more

0 comments, 7,361 reads

Posted in on 16 November 2014