Mehedi's Earth

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]

Recently, I was working in .Net framework and MySQL database. Below procedure was throwing error and finally, I found the solution. [More]

Application Performance Scalability to Success-3
 
Please join our techforumbd monthly webniar. [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]