Answer Posted / mathavan
Indexes are used for faster access of required data in a
large table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
how can you schedule a job in database?
What the different topologies in which replication can be configured? : sql server DBA
what is the role of dip user in our database?
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 operating modes in which database mirroring runs? : sql server DBA
how can you create a user-defined lock?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Explain about your sql server dba experience? : 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
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
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different ways you can create databases in sql server? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA