Mehedi's Earth

IDENTITY is widely used for generating the sequential value mainly for primary key. In some cases like failure of database or restarting of database might result in gap between the sequential value. Today we will have hands on experience on the IDENTITY Cache, it's limitation and way around. [More]

Technically, SQL Server does not support multiple IDENTITY Columns in a single table. Can we still achieve this? If yes, how? [More]

Let's discuss some more interesting and unusual use of IDENTITY function. Can we use negative value in identity column? [More]

Did you ever wondered how to INSERT values in IDENTITY column or fill the gap of missing value of ID [More]

In my Ranking Function article, I have briefly described about ROW_NUMBER() function. Let's have a p [More]

Explore the all four RANK functions of SQL Server [More]

This article will enlight on how to examine SQL Server Agent job status using T-SQL [More]

Explaining use of SQL CASE statement [More]

In some cases, I used linked server. If you use linked server you might get "Linked Server - Error 7 [More]

Use case of SQL Server INFORMATION_SCHEMA Views where your historical data tables are preserved by renaming. [More]