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.

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

What are recommended options to be used while using db mirroring? : sql server database administration

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

---

What is sub-query in sql server? Explain its properties.

0 Answers  

---

What command is used to create a database in the sql server and how?

0 Answers  

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

How many triggers you can have on a table?

0 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

What is the simplest way to create a new database in ms sql server?

0 Answers  

---

what is index seek and index scan?

2 Answers  

---