Interested to Buy Any Domain ? << Click Here >> for more details...
What is Check point? Explain in Brief what it will do?
- 1 Answers
- 5979 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 many type of subquery?
What is the template in sql?
what is node in sql server?
2 Answers CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How is a full-text index updated?
when inserting to a table how many rows will be effected using triggers
How to use group functions in the select clause in ms sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required
How to create a new table in a given schema?
How do I view a stored procedure in sql server query?
Explain the properties of the relational tables?
-
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)
