Blog

Partition Switching and Indexing

Minimize the maintenance downtime and increase availability in SQL Server 2014 by performingPartition Switching andOnline Index Rebuilding.

By Admin

Incremental statistics in SQL SERVER 2014

This sql server feature allows partition updates for partitions which in turn will be used as final statistics object. It is a very useful option when the partitions are present in the database.

By Admin

Control Transaction Durability

Learn how to control transaction durability. Delayed durability may result in data loss, as transactions are simultaneously logged and committed.

By Admin

Extended Stored Procedure – SQL Server 2014

An Extended Stored Procedure (XP) extends functions to other Microsoft applications. Learn to implement this feature on your database in this blog.

By Admin

SQL Server Database Disaster Recovery Techniques

When disaster strikes on a business database, a company could lose its entire data file. Learn how to put a Disaster Recovery Plan together.

By Admin