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 the use of ocr?
What is dcl? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What the different types of replication and why are they used? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
when does an alert gets signaled?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the recovery models for a database? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is dbcc? : sql server DBA