What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Explain cross join or cartesian product in sql?
Do you know what is lock escalation?
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
Explain what is log shipping?
Why use triggers?
What do you mean by an execution plan? Why is it used? How would you view it?
Explain activity monitors
how to control the amount of free space in your index pages? : Sql server database administration
Explain collation?
Creating Tables Using SELECT
What is an entity-relationship diagram (erd)?
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 Answers DELL, i Tech, Infosys, Siemens, TCS,