Answer Posted / monal
IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the steps you will take to improve performance of a poor performing query?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you initialize log miner?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain materialized views and how they are used.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how does an oracle clusterware manage crs resources?
what is a user-defined lock?
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