How will you optimize a stored procedure optimization?
No Answer is Posted For this Question
Be the First to Post Answer
How to remove duplicate rows from table except one?
How is sql server used?
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
What are the types of subquery?
What is best institute to Learn DotNET And SQL in chennai?
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??
What is meant by indexing?
How to assign null values to variables or columns?
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain about analysis services?
How many types of schemas are there?
syntax for deleting the database in T SQL