Performance is something every Developer struggles with at some point or other. In order to do optimization we can see query plan. This article will demonstrate as how we can create the function that will show us the query plan and how we can use it to see plans of objects that are highly used

[More]

In this article, we will see how we can increase the memory of SQL Server that it can use. Usually, default setting is 2147483647 bytes i.e. approximately 2.15 GB that SQL Server can use, but it may be required to increase the ram utilization as some of the query operations can be memory intensive and we want to avoid any Timeouts.

[More]