SQL

There are many new features in SSMS 2008. Here are some of them. This is copy/paster from some Book.  SQL Server 2008’s Management Studio ...

In SQL Server databases, the data is stored in heaps when the data is not logically sorted in the tables. This heap can sometimes display ab...

Are you facing problems in mounting a MS SQL Server 2008 database? Then, there are chances that the database (MDF file) is corrupt, which i...

The Activity Monitor is a great tool which can be used by database developers and administrators to get a quick overview of SQL Server 2008...

Sometimes it is required to copy a database to some other computer, for example for testing, checking consistency, developing software, run...