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 to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,


What are the database roles? : sql server security

0 Answers  


What happens if you are trying to access a schema not owned by you?

0 Answers  


What is query optimizer in sql server?

0 Answers  


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  






What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,


What are 3 ways to get a count of the number of records in a table?

0 Answers  


What to perform pattern match with the like operator?

0 Answers  


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  


How to enter comments in transact-sql statements?

0 Answers  


Tell me what is de-normalization and what are some of the examples of it?

0 Answers  


How to create a user name in a database?

0 Answers  


Categories