Sql Server - Find and Replace a value across all tables in database

Find and Replace a value across all tables in database

In my project I faced this problem due to typing mistakes....

Sql Server - Monitoring the Performance of All Stored Procedures

Monitoring the Performance of All Stored Procedures 

Every Project suffer from this problem, over the time they
have developed many stored procedure...

Sql Server - Monitoring the Performance of All Stored Procedures

Monitoring the Performance of All Stored Procedures 

Every Project suffer from this problem, over the time they
have developed many stored procedure...

Sql Server - Index Utilization Report

Index Utilization Report

One day my manager came and told me that he need Index Utilization Report.
He felt that during...

Most common interview questions

1.  Tell me about yourself.

Answer - Give summary of your past education and work, skills, and achievements and include your strong...

Getting ready for interview

Interview is a three stage process. Before => Interview => After

A. Before Interview -

1. Most important, ready your Resume/CV. Be confident about...