If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

550

how to restore files with rman?

1739

how can you process messages in order asynchronously?

551

what do you understand by fine-grained auditing?

620

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3931

What would you do with an "in-doubt" distributed transaction?

1411

which background process invoke at the time of upgradation tell me???

2217

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3790

Why would you call update statistics? : sql server DBA

569

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

2963

What are the different ways you can create databases in sql server? : sql server DBA

591

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

606

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

648

what is asm?

593

what is grd?

626