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
Do you know what is lock escalation?
What are secondary xml indexes?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What happens if time-only values are provided as date and time literals?
What is onf in normalization form?
How many replicas are maintained for each SQL Azure database?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is inner join in sql server joins?
Can you index views?
How do I find the query plan in sql server?
Explain tablesample?
What are the different types of data sources in ssrs?
What is importing utility?
Explain go command in sql server?
Is t sql the same as sql server?