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
Please explain what is “asynchronous” communication in sql server service broker?
What are Row versions of DataRow?
How to copy the tables, schema and views from one sql server to another?
List down some advantages of sql stored procedure?
can you instantiate a com object by using t-sql? : Sql server database administration
What is database white box testing?
How do I find the port number for sql server?
What are the different types of data sources in ssrs?
What are the basic functions for master, msdb, model, tempdb databases?
Write a query for primary key constraint with identity key word?
Explain the difference between function and stored procedure?
What is normalization? Explain its different types?
What do you understand by recursive stored procedures?
What are the difference between primary keys and foreign keys?
What are the new features in sql server 2016?