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 encrypt Strored Procedure in SQL SERVER?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How does a profiler work?
How do you create a clustered index?
Difference between server.transfer and server.execute method?
Name few of the dcl commands in sql?
What protocol does sql server use?
What does executeupdate return?
Can we insert data into view sql server?
What are the system database in sql server 2008?
Where in ms sql server is ’100’ equal to ‘0’?
Which table keeps the locking information?