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…
-
Android
Samsung Launched Galaxy J6, J8, A6, and A6+ Today in India
Just today, Samsung officially launched several of its Galaxy phones for the India market, from the Galaxy J and Galaxy…
-
Android
Huawei P20 Pro: Do you need the triple camera?
The regular P20 uses its dual camera configuration to offer 20MP maximum resolution colour images using some clever software, or…
-
News
Samsung G S9 Is Out Now Lets Focus on Samsung Galaxy S10
Samsung’s Galaxy S9 and S9+ are out and continuing to get the positive reviews all around although sales are down…