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

What is the use of Port no?

1 Answers   Wipro,


Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  


you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  


Explain what are the events recorded in a transaction log?

0 Answers  


What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,






Explain about Normalization?

0 Answers   Infosys,


how can i view structure of table in sql server? tell me that query.

10 Answers  


Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,


How would you choose between a clustered and a non-clustered index?

0 Answers  


1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,


Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,


What are magic tables in sql server?

0 Answers  


Categories