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 does an alert gets signaled?
What is dcl? : sql server DBA
How to start SQL Server in minimal configuration mode?
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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What the different topologies in which replication can be configured? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
how can you connect from 10g user to 11g user??
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what are the types of connection load-balancing?
What are the different sql server versions you have worked on? : sql server DBA
Explain materialized views and how they are used.
What is transparent data encryption? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
