Is truncate a dml command?
how to dispaly a particular row details from a given table
How many clustered indexes there can be on table ?
How to set the current database in ms sql server?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
How do I open a .db file?
is there a column to which a default can't be bound? : Sql server database administration
What is checkpoint process in the sql server?
What do you understand by triggers and mention the different types of it?
Describe in brief system database.
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
Explain what is row_number function?