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 |
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is sql server used for?
Explain the steps to create and execute a user-defined function in the sql server?
How to turn off warning messages during php execution?
How to defragment table indexes?
how many triggers you can have on a table? : Sql server database administration
What are the components of sql server service broker?
What is query optimization process?
What is normalization and denormalization in sql server?
What stored by the model? : sql server database administration
What is database replication? What are the different types of replication you can set up in sql server?
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
Oracle (3253)
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)