Answer / Saurabh Sonkar

"The basic functions of the SQL Server databases are as follows:nn- master: It is a system database that maintains metadata, security, and system configuration information about all databases on an instance of SQL Server.n- msdb: This is another system database that stores data related to SQL Server Agent jobs, alerts, history, and other system-related data.n- model: It is a user-defined template for new databases. Any changes made to the model database will be applied to any new databases created unless specifically overridden.n- tempdb: This is a temporary database that is used to store intermediate results, sorting data, and work tables during query execution. All objects in tempdb are dropped each time the SQL Server instance is restarted.n- resource: These are system databases that can be created by third-party applications. They are used to store application metadata and resources."

how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

1 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

What are the common performance issues in sql server?

1 Answers  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1 Answers  

---

What is sql server transaction log file?

1 Answers  

---

What is the purpose of forms?

1 Answers  

---

How do you clear a log file?

1 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---