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 is "scheduled jobs" or "scheduled tasks"?
Tell me something about security and sql azure?
Explain Normalization and DE normalization
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is a coalesce function?
Explain various On-Delete options in a DB table. Which is the default option?
What are the types of database recovery models?
How to make remote connection in database?
What is the importance of a recovery model?
What are the encryption mechanisms in sql server?
What is the use of =,==,=== operators?
How to change the name of a database user?
Write an sql query to find first weekday of the month?
How to create a login account in ms sql server to access the database engine using "create login" statements?