Define Check points and End Points?



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

Explain microsoft sql server functions?

0 Answers  


How do I manually uninstall an instance of sql server 2016?

0 Answers  


how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  


How does normalization work?

0 Answers  






How do you fine the performance tunning?

2 Answers   Accenture,


Explain about protocol layer present in SQL server?

0 Answers  


Explain triggers in sql?

0 Answers  


WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  


What is the purpose of data source?

0 Answers  


When columns are added to existing tables, what do they initially contain?

0 Answers  


What is openrowset sql server?

0 Answers  


Categories