Script to find the Fragmentation of indexes

Below is the script to find the fragmentation of the indexes created on a database.

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...

Script to find all the running queries/jobs on the Database Server

Below is the query to find out all the Queries and their details like SSID etc. running on the SQL...

How to pass Microsoft Certification Exams

Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,...

Interview questions for database developer

Technical Round Database Interview Questions

1) What are the different types of Trace flags which we used for detecting the Deadlock?
2)...

My Best LinkedIn Articles

Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.

7 Bad Management...

My Best Technical Sites and Blogs

Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the...

SQLTea - New SQL tutorial app in Google play store

SQLTea - Our new SQL Tutorial App on Google Play StoreWe are happy to announce our new SQL tutorial app SQLTea...

How to restore database backup in SQL SERVER

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In...

How to take Database backup in SQL SERVER

This article explain the simple way to take up the backup of a database which can be easily understandable by...

Database Creation using SQL Sever Management Studio (SSMS)

In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command....