Define Check points and End Points?

Answer Posted / veeresh kethari

CheckPoints:Whenever we perform any DML operations in the
database,it will go to the checkpoint and then commit in
the database.If we don't have checkpoints,the data will get
store in transaction log file,once it got fill full,it will
make the database performance issues.
Endpoints:Endpoints are objects that represent a
communication point between the server and a client.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can the “if update (colname)” statement be used in a delete trigger?

535


What are cursors stored procedures and triggers?

498


How secure is sql server database?

505


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

544


What is difference between commit and rollback when used in transactions?

474






How can delete duplicate records in cte in sql server?

497


Explain log shipping and mention its advantages.

573


write an SQL query to list the employees who joined in the month of January?

1119


Why use sub query in sql server and list out types of sub queries?

515


What is transaction server isolation?

552


Explain encryption of entire databases without the need for application changes in sql server 2008?

539


How to use union to merge outputs from two queries together in ms sql server?

539


What is 2nf normalization form?

582


What are different types of views?

529


what is the system function to get the current user's user id? : Sql server database administration

533