Books VS Internet

It’s is very easy to be
confused between investing in books or we should use the power of internet. If
you ask...

Sql Server - Detecting and Monitoring Memory Pressure

Introduction - Detecting and Monitoring Memory Pressure 

I will be writing this article in four parts because this
topic is huge and amount...

Interview Questions for Companies

In this article I will be posting interview questions by companies. Whenever I am facing any interview or someone shares...

SQL Server Interview Questions And Answers

This is post going to be more like a list of question for self assessment. So I will not be...

SQL Server Interview Questions And Answers

This is post going to be more like a list of question for self assessment. So I will not be...

Sql Server - Finding Duplicate Indexes

If you are reading this article, I assume
that you have basic knowledge of Index, its types and usage.

Over the...

Sql Server Special Table Types

Special
Table Types

Objective of this post is to provide a list of special
tables available in Sql Server and brief description of...

Sql Server – Statistics (Create, Update and delete Statistics)

Sql Server – Statistics (Create, Update and delete Statistics)

If you are reading this Article, I assume that you know the basics...

Sql Server – Listing all tables Metadata (Table Size, row count, Index Size)

Sql Server – Listing all
tables Metadata (Table Size, row count, Index Size)

Suppose you need to find out Table size, row
count , index...

Sql Server - Top Slowest Queries or Resource Extensive Queries

Top
Slowest Queries or Resource Extensive Queries

Whenever your database is facing any performance issue or resource scarcity,
the first step should be...