the process of adding a cpu in sql server is called..?
Answer Posted / suri
Through security in SQL u can add as
Linked servers
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the commands you'd issue to show the explain plan for "select * from dual"?
Why would you use sql agent? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Where would you look for errors from the database engine?
What is the importance of a recovery model? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you create a user-defined lock?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?