1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Define Check points and End Points?

Question Posted / vamsimadineni


Define Check points and End Points?..

Answer / 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

More SQL Server Interview Questions

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

How many types of Cursor in SQL SERVER?

1 Answers  

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  




List out the differences between global and local temp tables in sql server?

0 Answers  

What are system databases in ms sql server?

0 Answers  

What is the difference between locking and multi-versioning?

0 Answers  

How to verify the port number of the sql server?

0 Answers  

What are the features of Embedded SQL

0 Answers   HCL,

Can we take the full database backup in log shipping?

0 Answers  

What do you understand by check constraint in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories