What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
1098What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
1104What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
1031When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
983Due 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
1012What is the difference between dropping a database and taking a database offline? : sql server DBA
1057Post New DB Administration Questions
What the different components in replication and what is their use? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What is the default fill factor value? : sql server DBA
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
What are the steps you will take to improve performance of a poor performing query?
how can you implement fine-grained auditing?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is dcl? : sql server DBA
how can you enable flashback feature?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is a system database and what is a user database? : sql server DBA
what is a crs resource?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Where would you look for errors from the database engine?
What is dbcc? : sql server DBA