SQL Server and Windows 2008 Server Core Installation

Microsoft has introduced an option in Windows 2008 installation which is called Server Core. This option allows you to install a smallest possible footprint of Operating System for a specific role to be performed by the server like File Server, Domain Controller etc. This installation does not have usual graphical interface of OS like Windows [...]

How SQL Server 2008 Data Compression works?

From many new features of SQL Server 2008, one of the best is the introduction of Data Compression which allows you to enable or disable data compression at row or page level.
Data compression is a sensitive issue in context of databases. Some people have opinion that if we compress data at database level to reduce [...]

Quickest way to find the recovery model of any database

This article provides you the quickest way to find the recovery model of your database in a single TSQL query