Interested to Buy Any Domain ? << Click Here >> for more details...
What is Check point? Explain in Brief what it will do?
- 1 Answers
- 6087 Views
- Wipro, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 3 Yes | 2 No |
How can sql injection be stopped? : sql server security
What is the diff between Static Queries and Dynamic queries give me some examples
What is meant by dirty read?
Define full outer join in sql server joins?
What are the mathematical functions supported by sql server 2005?
What is local temp table?
How to insert stored procedure result into temporary table?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is live lock and deadlock? what is Lock escalation?
How important do you consider cursors or while loops for a transactional database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
