Database Recovery

Database Partitioning – Key concepts every DBA must know

In this article we would go through the key concepts associated with Database partitioning in SQL Server Partitioning in SQL Server is used for easy maintenance and improved performance of the database. It allows splitting of large tables along with individual tables. Queries which require access to limited data can be performed quickly as the data to be scanned is lesser. Maintenance task like rebuilding indexes or backing up tables, can be performed quickly. Partitioning does not always...

Read more »

A Quick lowdown on SQL Server Clusters

In this article we take an in-depth look into SQL Server clusters and learn how they can prove beneficial to an organization. Clustering in SQL Server refers to the installation of multiple instances of SQL Server into one or more physical servers, preferably ones running on Microsoft Windows. This is done to add on to the availability of the database, as a clustered SQL Server database will be available across the clustered servers at all times. So in case either of the server crashes, the...

Read more »

Understand the Relevance of Archiving Data in SQL Server

In this article we look at why it is important to archive data in SQL Server Archiving data refers to separately storing data that is currently not in use, but might be used for future purposes. Archived data is stored separately from the data currently in use so that excess data does not slow down the performance. It is important to archive data in SQL server as databases are usually very heavy files, and storing all databases, even those not in use on a single system will affect...

Read more »