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.

What is Dedicated Administrator Connection in sql server 2005?

2 Answers  

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---

Explain what is use of dbcc commands?

0 Answers  

---

How fixed length strings are truncated and padded?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

What is the difference between delete and truncate statements?

0 Answers  

---

Explain activity monitors

0 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

explain extended properties

0 Answers  

---

What are the kinds of subquery?

0 Answers  

---

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,

---