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 we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,


How to drop an existing user defined function in ms sql server?

0 Answers  


What are different types of schemas?

0 Answers  


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  


how insert selected column only ?

3 Answers   Robert Half,






How to loop through the result set with @@fetch_status?

0 Answers  


employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  


How to delete an existing row with delete statements in ms sql server?

0 Answers  


What are relationships and mention different types of relationships in the dbms

0 Answers  


How to convert a unicode strings to non-unicode strings?

0 Answers  


What is dimension table? : sql server analysis services, ssas

0 Answers  


List the advantages of using stored procedures?

0 Answers  


Categories