What is the optimization being performed in oracle and SQL Server?


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

Post New Answer

More SQL Server Interview Questions

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

0 Answers  


What is always encrypted?

0 Answers  


you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  


Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,


What is meant by indexing?

0 Answers  






Display a roll having miminum marks in two subjects?

7 Answers   Patni,


Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  


How to insert and update data into a table with "insert" and "update" statements?

0 Answers  


How to create database with physical files specified in ms sql server?

0 Answers  


how can u get last observation in an unknown dataset ?

0 Answers   Genpact,


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

0 Answers  


sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  


Categories