Recently, I was in need to generate a report to find out how many customer calls daily within 10 AM
[More]
25. August 2020
Mehedi
SQL Tips
Now SQL Server extends built-in support to the popular data exchanging format JSON. It exposes couple of functions for verifying, retrieving and updating JSON string. Let's carefully check them.
[More]
21. August 2020
Mehedi
SQL Tips
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]
19. August 2020
Mehedi
SQL Tips
Technically, SQL Server does not support multiple IDENTITY Columns in a single table. Can we still achieve this? If yes, how?
[More]
19. August 2020
Mehedi
SQL Tips
Let's discuss some more interesting and unusual use of IDENTITY function. Can we use negative value in identity column?
[More]
5. August 2020
Mehedi
SQL Tips
Did you ever wondered how to INSERT values in IDENTITY column or fill the gap of missing value of ID
[More]
29. July 2020
Mehedi
SQL Tips
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
Explore the all four RANK functions of SQL Server
[More]
16. July 2020
Mehedi
SQL Tips
This article will enlight on how to examine SQL Server Agent job status using T-SQL
[More]
15. July 2020
Mehedi
SQL Tips
Explaining use of SQL CASE statement
[More]