Answer / veeresh kethari

CheckPoints:Whenever we perform any DML operations in the
database,it will go to the checkpoint and then commit in
the database.If we don't have checkpoints,the data will get
store in transaction log file,once it got fill full,it will
make the database performance issues.
Endpoints:Endpoints are objects that represent a
communication point between the server and a client.

Explain transaction server explicit transaction?

0 Answers  

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

Explain left outer join and right outer join?

0 Answers  

---

How to use column default values in insert statements in ms sql server?

0 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

Why functions are used in sql server?

0 Answers  

---