Define Check points and End Points?
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 |
How to delete a database in ms sql server?
What is a trigger and types of a trigger?
why SQL server is more used to store database rather than Access
What is a performance monitor?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
What happens to a trigger with multiple affected rows?
What are locks in sql?
What is Deadlock?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
What is an indexing technique?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are the parts of a function?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)