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

Advertisements

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

Understanding and Implementing Transparent Data Encryption (TDE) – SQL Server 2008

Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files. The encryption uses a database encryption key (DEK), which is stored in the database boot record for availability during recovery.

Continue reading

SQL Server Practice Test – Online

Folks,

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..

http://www.sql-server-helper.com/free-test/default.aspx

Thanks

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

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