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 dirty page?
How adventureworkslt tables are related?
What type of Index will get created after executing the above statement?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is data compression?
Can we use trigger new in before insert?
What are click through reports?
How do you trace the traffic hitting a sql server?
Mention the 3 ways to get a count of the number of records in a table.
Why we use functions in sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How is sql used in sql server?
How to create a stored procedure with a statement block in ms sql server?
How to count groups returned with the group by clause in ms sql server?
Can we install sql server 2016 on windows 7?