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

Posted Under: Information, Performance, SQL Server 2008, Windows 2008
This post was written by namwar on April 27, 2008 Comments (3)

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

Posted Under: Information, SQL Server 2008
This post was written by namwar on April 22, 2008 Comments (0)

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

Posted Under: How-To, Object Search, Query, TSQL, Tips
This post was written by namwar on April 16, 2008 Comments (0)