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
Can the “if update (colname)” statement be used in a delete trigger?
What are cursors stored procedures and triggers?
How secure is sql server database?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is difference between commit and rollback when used in transactions?
How can delete duplicate records in cte in sql server?
Explain log shipping and mention its advantages.
write an SQL query to list the employees who joined in the month of January?
Why use sub query in sql server and list out types of sub queries?
What is transaction server isolation?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to use union to merge outputs from two queries together in ms sql server?
What is 2nf normalization form?
What are different types of views?
what is the system function to get the current user's user id? : Sql server database administration