Category: General
-
Locks & Locking Hints
Introduction: Locking, Locks and Deadlocks are words that a developer/DBA does not want to hear in real life but still there are possibilities that we hear them because of some bad code written. This article takes you on to the type of locks available in SQL server and the ways of avoiding them using the…
-
Upgrading to SQL Server 2005
Introduction: As we all know that Microsoft has released SQL Server 2005 sometime back and is planning to release the next version KATMAI before end of 2008. Also it has announced the end of life cycle support for SQL Server 2000. Its high time that we start with upgrading our instances with SQL Server 2005…
-
SQL 2005 Edition Comparison
Introduction: SQL Server 2005 comes with different editions with each having features that are either available in the other or not. This document lists the comparison of the features available between the different editions.