Why is there a performance difference between two similar queries where one uses union and the other uses union all?
No Answer is Posted For this Question
Be the First to Post Answer
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the difference between insensitive and scroll cursor?
what are candidate key, alternate key and composite key? : Sql server database administration
Can we rewrite subqueries into simple select statements or with joins? Example?
Can we store videos inside the sql server table?
Can we do dml on views?
How will you decide the active and passive nodes?
What do you understand by integration services in sql server?
What are types of subqueries?
What is resource governor?
How to convert binary strings into integers in ms sql server?
What is split brain scenario in DB mirroring?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)