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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What purpose does the model database server? : sql server DBA
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 is the default port no on which sql server listens? : sql server DBA
how can you communicate with operating system files from oracle?
which background process invoke at the time of upgradation tell me???
What are the different ways you can create databases in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you initialize log miner?
What happens on checkpoint? : sql server DBA
What is a system database and what is a user database? : sql server DBA
what are the benefits of flashback feature?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.