What are the basic rules to be followed when you are using SQL SET Operators?

Rules: Number of columns in all the result sets should be matched(same). Respective data types should be matched between all the result sets.

Read More

What are the advantages of using CTEs?

Advantages: Query performance will be improved by replacing sub queries with CTEs. Code Complexity will be reduced. It will not be burden to database since its scope is till the next statement. Happy Reading

Read More

Delete vs Truncate

Delete It is a DML command We can use filters in WHERE clause to delete the data Removes specified data only Deletes one row at a time Records removed data in transaction logs It does not resets the identity field of the

Read More

Why Truncate is faster than Delete?

When we are Deleting the records from a table, it does the following. Read the required records based on Where condition Deletes each record one by one and also updates the transaction log Update Indexes Check for Constraints on the table Check

Read More