Muhammad Ussama
Creating Clustered and Non-Clustered Indexes in SQL Server
In a SQL Server, two types of indexes exist; Clustered and non-clustered indexes. Both clustered indexes and non-clustered indexes have…
How to Setup Database Mail in SQL Server using Gmail?
With SQL Server 2005 many things have been changed. In earlier versions in order to make it work, SQL Mail…
How to Remove Duplicate Rows from a SQL Server Table?
When designing objects in SQL Server, we must follow certain best practices. For example, a table should have primary keys,…
How to Rename a SQL Server database?
Sometimes we need to change database name because the original name was based on the project that has become irrelevant…
How to Fix the Error ‘Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF’?
The primary key column is often set to auto-increment when constructing a SQL Server database. The IDENTITY limit is set…