optimization techinques
No Answer is Posted For this Question
Be the First to Post Answer
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??
How to store and query spatial data?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the difference between nvl and nvl2?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Can you explain what are commit and rollback in sql?
What is the difference between resultset and resultsetmetadata?
What are the types of constraints?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
what is the importence of the trigger in sqlserver2000?
How do I start sql server 2016?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,