Category Archives: SQL Advanced

T-SQL script to find the highly populated tables in database

Posted on January 9, 2015 by vivekjohari

Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we can use to find out that. SELECT      t.NAME AS TableName,     i.name as indexName,     sum(p.rows) … Continue reading →

Posted in DBA, SQL Advanced, SQL Server | Tagged , | 27 Comments

SQL Script to find the last executed commands on the SQl Server

Posted on January 8, 2015 by vivekjohari

Sometimes we needs to find out the last executed commands on the database server.  Below is the SQL script share by one of my friend Ken Watson to find out the last executed queries. SELECT usecounts, cacheobjtype, objtype, text  FROM … Continue reading →

Posted in DBA, SQL Advanced, SQL Server | Tagged | 30 Comments

Script to find the Fragmentation of indexes

Posted on January 4, 2015 by vivekjohari

Script to find the Fragmentation in Indexes In my previous articles, Fragmentation in SQL Server and Rebuild And Reorganization of Indexes , we talk in detail about Index fragmentation and rebuild or reorganize the indexes. Below is the SQL script which we … Continue reading →

Posted in DBA, SQL Advanced, SQL Indexes, SQL Server | Tagged , | 33 Comments

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

Posted on January 4, 2015 by vivekjohari

Below is the query to find out all the Queries and their details like SSID etc. running on the SQL Server from all databases. It helps in finding out which queries/jobs running on the server. It can be helpful in … Continue reading →

Posted in DBA, SQL Advanced, SQL Server | Tagged , | 3 Comments

How to pass Microsoft Certification Exams

Posted on January 3, 2015 by vivekjohari

Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view, it simple to crack Microsoft certification exams if you have worked hard on basic concepts and implemented most of the … Continue reading →

Posted in Miscellaneous, SQL Advanced, SQL Server | Tagged , | 15 Comments

How to restore database backup in SQL SERVER

Posted on August 17, 2014 by vivekjohari

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little … Continue reading →

Posted in SQL Advanced, SQL Database Restoration, SQL Server | Tagged , | 30 Comments

Deleting Duplicate rows using CTE

Posted on December 29, 2013 by vivekjohari

Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example … Continue reading →

Posted in Interview Questions, SQL Advanced, SQL CTE, SQL Server | Tagged | 26 Comments