Group items tagged

In ASP.Net, we usually use Microsoft SQL server as our backend for storing data. In this article, we will understand that how we should use query execution plan for performance optimization of SQL server.

In this post, we are going to explain how you can list all CONSTRAINT of database or table in SQl Server. When you are working on database sometimes you need to check or get the CONSTRAINT on database or table. Using below given query we can get the CONSTRAINT of table or database quickly.

This tutorial talks about how to handle error in SQL Server using THROW.

In this post, we will convert a given date of range into list of dates as per the business requirement.