How will you find out if there are expensive SQL statements running or not?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Why functions are used in sql server?
Difference between sql server 2000 and sql server 2005?
11 Answers Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is star, snowflake and star flake schema? : sql server analysis services, ssas
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is transaction server explicit transaction?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
How does clustered and non clustered index work?
What is a schema in ms sql server 2005?
What are the different ways you can create databases in sql server?