Category Archives: SQL Advanced

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

By | January 9, 2015

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) as RowCounts,     sum(a.total_pages) as TotalPages,      sum(a.used_pages) as UsedPages,      sum(a.data_pages)… Read More »

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

By | January 8, 2015

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 sys.dm_exec_cached_plans  CROSS APPLY sys.dm_exec_sql_text(plan_handle)  WHERE usecounts > 1  ORDER BY usecounts DESC;  About Ken He… Read More »

Script to find the Fragmentation of indexes

By | January 4, 2015

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 can use to find the Fragmentation in Indexes created on the database. SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,… Read More »

How to pass Microsoft Certification Exams

By | January 3, 2015

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 questions and scenarios mention in your study books/blogs on your system. 1) Take out the list… Read More »

How to restore database backup in SQL SERVER

By | August 17, 2014

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 knowledge of DBA can restore that database using the database backup. For database restoration process,… Read More »