Answer / samba shiva reddy . m

When we done operation on SQL SERVER that is not commited directly to the database example:we are deleting bulk records from server but in between power shut down or some thing happened then that transaction is not committed from our side if we create check point on that delete statement after deleting some records it will save as check point next no need to delete those records again if check point is not there means we have to start form scratch.All operation must be logged in to Transaction Log files after that they should be done on to the main database.CheckPoint are the point which alert Sql Server to save all the data to main database if no Check point is there then log files get full we can use Checkpoint command to commit all data in the SQL SERVER.When we stop the SQL Server it will take long time because Checkpoint is also fired.

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---

How do you persist objects, permissions in tempdb

1 Answers  

---

What is sql server profiler trace data file?

0 Answers  

---

What is unpivot?

0 Answers  

---

What do you understand by the denormalisation?

0 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

What is clustered primary key?

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

What does top operator do?

0 Answers  

---

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

---