What are Global variables in SQL Server and how to create them?

In SQL Server, there is NO concept of Global variables. In the initial versions of SQL Server, the System defined functions which begin with ‘@@’ are referred as Global variables. But their actual behavior is not same as variables in SQL Server.

Read More

What is Denormalization?

Denormalization is the process of optimizing the performance of a database by adding redundant data. It is the responsibility of database designer to denormalize up to some extent which should not impact the cost of the database. It plays vital role in

Read More