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
what is a crs resource?
what do you understand by fine-grained auditing?
how can you communicate with operating system files from oracle?
What is the default port no on which sql server listens? : sql server DBA
What is transparent data encryption? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different types of indexes available in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What would you do with an "in-doubt" distributed transaction?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the commands used in dcl? : sql server DBA