Mehedi's Earth

An use case of ROW_NUMBER() Function

29. July 2020 Mehedi SQL Tips Comments (0)

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

28. July 2020 Mehedi SQL Tips Comments (0)

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

16. July 2020 Mehedi SQL Tips Comments (0)

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

15. July 2020 Mehedi SQL Tips Comments (0)

Explaining use of SQL CASE statement [More]

13. July 2020 Mehedi SQL Tips Comments (0)

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

13. July 2020 Mehedi SQL Tips Comments (0)

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