Solutions

6 Crucial Indexing Best Practices and Priorities in SQL Server that You Must Keep in Mind

This article explains the relevance and importance of indexing in SQL Server along with explaining the best practices and priorities to follow when creating indexes in SQL Server. Understanding of Indexes and their practices is essential if you are working with SQL Servers and database management. Indexes speed up the search process in the database up to a great extent as it can effectively find all relevant rows matching columns from your query. There are two types of indexes, Clustered...

Read more »

4 Salient Differences between Heap Tables and Clustered Tables in SQL Server

The following article explains the key differences between Heap tables and Clustered tables. While working with tables in SQL Server, users often face the dilemma to use clustered tables or heap tables. Tables which don’t have clustered indexes are called Heap Tables and those having clustered indexes are called Clustered Tables. A Clustered index basically reorders the way in which records are stored physically in a table. The data pages are contained in the leaf nodes of a clustered...

Read more »

How to Get More Juice Out of a Secondary Replica on an AlwaysOn Availability Groups in SQL Server

In this article, we understand how to make the most out of secondary replica for AlwaysOn Availability Groups. Users working on SQL Server are familiar with AlwaysOn feature available in 2012 and subsequent editions. AlwaysOn availability groups help users in providing higher availability, read scale balancing and disaster recovery. There is an Active Primary replica and along with is a secondary replica which is passive. So the essential question is how can we assign certain tasks to...

Read more »