- Server Administration
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…
- Gmail
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…
- Server Administration
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,…
- Server Administration
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…
- Server Administration
How to Fix ‘Can’t insert explicit value for identity column in table’
The primary key column is often set to auto-increment when constructing a SQL Server database. To achieve this, the IDENTITY…
