Where do we generally create INDEX?
Answer Posted / ram
in tables to retrieve data from the database
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between LEN() and DATALENGTH() in sql server ?
Explain index in sql server?
What is user-defined inline table-valued function?
What is the optimization being performed in oracle and SQL Server?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
List the different normalization forms?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Explain about builtinadministrator?
What do you understand by recursive stored procedure?
How can you fetch alternate records from a table?
What do you understand by triggers and mention the different types of it?
Describe how to use the linked server?
Do you know the policy based administration feature of sql server 2008?
How to create a scrollable cursor with the scroll option?