What is the difference between Primary key and Foreign key?

Primary key: It Identifies each and every record uniquely We can create only one Primary key on a table Primary keys do not accept NULL values It creates a clustered index in the table by default Foreign key: It makes the relation

Read More

What is a Filtered Index?

Filtered Index Filtered Indexes are one of the best performance boosters of SQL Server. This was introduced in SQL Server for reducing the maintenance and storage cost. Filtered Indexes are the Non Clustered Indexes which are created on a column(s) to filter and

Read More

What is COALESCE() function?

It’s a kind of decision making function and it contains more than one expression. When we are executing this, it first checks for the first expression and moves forward if it returns NULL value. Otherwise it returns value of the first expression.

Read More