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
What do you mean by the term 'normalization'?
Can I disable or restrict ssrs export formats (rendering formats)?
What are dml triggers and types of dml triggers?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the ‘fillfactor’?
What is the difference between function and stored procedure in sql server?
What is the difference between a function and a trigger?
What is an identity column in insert statements?
How many database files are there in sql server 2000?what are they?
Explain what is scheduled job and how to create it?
How to delete a login name in ms sql server?
How do you rebuild an identity column?
Explain indexed views and partitioned view with their syntax.
How to achieve Paging of records in SQL SERVER?
How to create a simple stored procedure in ms sql server?