Sqlserver Interview questions

Total available count: 45
Subject - Databases
Subsubject - Sqlserver

What is the difference between UNION and UNION ALL?

The UNION ALL statement is much faster than UNION. Because UNION ALL statement does not look for duplicate rows, and UNION statement does look for duplicate rows, whether or not they exist.

Next 5 interview question(s)

What are the authentication modes in SQL Server?
What are the properties and different Types of Sub-Queries?
When is the use of UPDATE_STATISTICS command?
What is difference between DELETE and TRUNCATE commands?
What are the difference between clustered and a non-clustered index?