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 are the steps to process a single select statement?
How can you know if the row fetched from cursor is still valid in underlying table?
How to use group functions in the select clause in ms sql server?
Explain the collation?
What is join and name different type of joins?
What is dbcc command in sql server?
Can we perform backup restore operation on tempdb?
What is #table in sql server?
What is linked report?
What are the steps to follow to configure SQL*Net?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Explain about system stored procedure?
What is 1nf 2nf?
How you can get a list of all the table constraints in a database?
What is named calculation? : sql server analysis services, ssas
