Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

How can we insert data from one table to another table without using import/export wizard?

How will you create one table (new table) from another table (source table). The new table should be empty after creation?
Continue reading


Quick Way to Create Single Table Backup

There are several ways to create backup for a single table in SQL Server database. In SQL Server 2008, now you can create insert statements for selected tables. Beside this Export wizard is commonly used to create a flat file backup for a single table. Both methods are reliable but still time consuming. And when I searched for quickest method to take backup of a single table I found following code by SQL Expert Fred. Continue reading

Moving System Databases – SQL Server 2005

Here I have tried to explain how we can move system databases from one place to another step by step from my experience.

Please follow the below Tasks for moving system databases:

Continue reading

SQL Server Practice Test – Online


I have found a very good link of SQL Server Practice Test which is an online test….

I thought why not to share, Please follow the below link..


Lock pages in memory – SQL Server

This security setting determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory on disk. Exercising this privilege could significantly affect system performance by decreasing the amount of available random access memory (RAM). Continue reading


SP_recompile needs a single parameter which is the table name after it.

ie: sp_recompile table_name Continue reading

Routine Backup & Restore Queries

The following is the query for recent 100 records for database backups.
you get results by changing backup type below

D= Full backup
L= T-Log backup
I=Incremental or Differential Continue reading