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.

Tell me what is the difference between locking and multi-versioning?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

---

What is sql collation?

0 Answers  

---

How use inner join in sql server?

0 Answers  

---

What is shared lock?

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

How to write character string constants or literals in ms sql server?

0 Answers  

---

What languages bi uses to achieve the goal?

0 Answers  

---