Why union all is faster than union?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How do you start single user mode in clustered installations?

0 Answers  


Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,


what types of replication are supported in sql server? : Sql server database administration

0 Answers  


What is nonclustered index with included columns ?

0 Answers  


What is the security principal at the server level that represents your session?

0 Answers  






please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,


What is the use of stored procedure?

0 Answers  


How you can find out if an index is useful to the optimizer?

0 Answers  


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  


Is null vs coalesce?

0 Answers  


how to replace double quotes by single quotes in sql server

2 Answers   CAC,


what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  


Categories