SQL-Articles

New article on “Policy Based Management” is posted in our main website. Check the article from the link given below.

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 enforce consistent policies across all servers.

Policy Based Management - SQL Server 2008

New article on “Temp table VS Table variable” is posted in main website. Check it out from the link below

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

Temp table VS Table variable

New article on Moving mirrored database is posted in our main website. This article describes how to move the database files of a mirrored database to a new location without any downtime. You can check the article from the link below.

How to Move mirrored database files

New article on Index fragmentation posted in main website, check the article in the link below.

Index Fragmentation in SQL Server 2005

New article on SQL Server 2005 Best Practices posted in main website, you can read the article from the link below.

SQL Server 2005 Best Practices