How do you create an execution plan?
What is your recommendation for a query running very slow? : sql server database administration
what is trigger . hw will it use them
Explain following error properties?
Explain the different index configurations a table can have?
When is the use of update_statistics command?
Can a database be shrunk to 0 bytes, if not, why?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the purpose of optimization?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
Can sql server be linked with other servers like oracle?
Suggest a method of joining two tables.
0 Answers Ernst Young, Thomson Reuters,
What are key constraints?