How will you optimize a stored procedure optimization?


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

Post New Answer

More SQL Server Interview Questions

How to remove duplicate rows from table except one?

0 Answers  


How is sql server used?

0 Answers  


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  


What are the types of subquery?

0 Answers  


What is best institute to Learn DotNET And SQL in chennai?

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  


What is meant by indexing?

0 Answers  


How to assign null values to variables or columns?

0 Answers  


When I run the sql server 2000 setup, it just hangs. What do I do?

0 Answers  


Explain about analysis services?

0 Answers  


How many types of schemas are there?

0 Answers  


syntax for deleting the database in T SQL

5 Answers  


Categories