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 |
Explain microsoft sql server functions?
How do I manually uninstall an instance of sql server 2016?
how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?
16 Answers Accenture, IBM, Marlabs,
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How does normalization work?
How do you fine the performance tunning?
Explain about protocol layer present in SQL server?
Explain triggers in sql?
WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?
What is the purpose of data source?
When columns are added to existing tables, what do they initially contain?
What is openrowset sql server?