Category: Articles
-
Policy Based Management – SQL Server 2008
This article discusses the new feature named Policy Based Management in SQL Server 2008. Policy Based Management is an extensive management configuration that can be used to manage servers, databases and objects. Policy Based framework provides a way to define policies that apply to servers, databases and objects. With Policy based Management framework, you can…
-
Temp table VS Table variable
Most of the SQL Developers/DBA would have come across a situation where they need to store the temporary result sets. This is where Temp tables and Table variables come into effect and helps in storing the data sets in a temporary location.
-
How to Move mirrored database files
The following article describes how to move the database files of a mirrored database to a new location without any downtime. Basically I have the following scenario:
-
Index Fragmentation in SQL Server 2005
Index fragmentation is a phenomenon where the index contents are scattered. Normally the contents are in contiguous fashion which helps in fast retrieval of the underlying data. When the indexes are fragmented the data access becomes time consuming because of the scattered data that needs to be searched and read.
-
SQL Server 2005 Best Practices
This article lists the best practices for SQL Server 2005