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.

How to use order by with union operators in ms sql server?

0 Answers  

---

How to find the service pack installed? : sql server database administration

0 Answers  

---

How to perform key word search in tables?

0 Answers  

---

What is a collation in ms sql server?

0 Answers  

---

What do you understand by mirroring?

0 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

What are the underflow and overflow behaviors on float literals?

0 Answers  

---

What is the use of sign function?

0 Answers  

---

How can you stop stored procedures from recompiling?

0 Answers  

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

Why I am getting this error when renaming a database in ms sql server?

0 Answers  

---