Detail about query optimizer?


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

Post New Answer

More SQL Server Interview Questions

What do you mean by an execution plan? How would you view it?

0 Answers  


select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,


Can binary strings be converted into numeric or float data types?

0 Answers  


How will you hide an attribute? : sql server analysis services, ssas

0 Answers  


How to verify a login name with sqlcmd tool?

0 Answers  






How to return the date part only from a sql server datetime datatype?

0 Answers  


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  


difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  


What does null mean?

0 Answers  


What are logical/boolean operations in ms sql server?

0 Answers  


what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,


Categories