Saturday, 19 January 2013

What are the System Databases in SQL Server

Database: Database is like a place holder to store the data. The data will be stored in the defined order. Any server may contain more than one database to store different kinds of data based on the requirement.


Tuesday, 15 January 2013

Post Installation of SQL Server 2008

We can test the installation of SQL Server by using the configuration manager. The configuration manager will display the SQL Server services of all the instances currently those are running on this machine.

How to Copy Data from One Table to another Table in SQL Server 2008

We can follow the follow the number of ways to copy data form one table to another table within the same database or other databases either within the same SQL Server instance or other SQL Server instance.