What is sql server agent and what are the two modes of authentication in sql server?
How to create an identity column?
Can we passed multiple recordset(set of records) using a Stored Procedure
How many instances per computer are there in sql server 2000?
what are the disadvantages of cursors? : Sql server database administration
What do you mean by an execution plan?
What is RAID and what are different types of RAID configurations?
internal language used in sql server 2000?
How to generate create function script on an existing function?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
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