I always want to test my .NET based application on my personal Gitlab based repo. But since, my old project is too much a mess to do the effort for….
Category: MS SQL Server
SQL Update if Record Exists or Insert
Quite often we need an approach where we need to Insert record if it is not already present. Sometime to manage relationship. There are few different way of doing it,…
Advance SQL: Finding Hierarchical data using Recursive CTE
Often we have a Table that store Hierarchical data, such as any shopping cart will have product category in table that store parent table within same table. We often use…
Reading Large Binary Files: Child Play
Yes, that was funny title, but after your experience it you will agree to me. So, here is the story. I have been working on a software that read some…
Database Optimization
Well, most of program use database for their web application. Eventually all web application does have database. But how many of those web application really works good. Well quite few….
Case Sensitive Search in SQL Server
Mysql mostly provide a Case sensitive search because of its default collate configuration. However SQL server use different collate and hence by default it is not case sensitive. It is…
Sql optimization
Today, I experience a slow down in one of website I just finish building up. It was a intereting project which has ability to create Dynamic form and hence the…