Category: SQL Server

Difference between Primary Key and Unique Key

By default, primary key creates clustered index on the column and then enforces the uniqueness of the column whereas the unique key, by default creates a non-clustered index. Primary Key By default, creates Clustered index …

Open DBDiff for SQL Server 2008

Last few weeks , i have been playing around with this cool tool called Open DBDiff . As the name suggests Open DBDiff tool lets you compare the database schema for SQL Server 2005 or …