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
How do I create an extended event in sql server?
What is simple indexing method?
What are the different subsets of sql?
Is the order of columns in the set clause important in ms sql server?
Explain about nested stored procedure?
what are the reporting service components in SSRS?
What is difference between oltp and olap?
Where views are stored in sql server?
What is 2nf example?
what is denormalization? : Sql server database administration
What is forward - only cursors / read only cursor?
What is msdb database? : SQL Server Architecture
Difference between connected and disconnected database in .net with sql server?
What is code near application topology?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
