What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
1117What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
1119What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
1051When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
1000Due 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
1031What is the difference between dropping a database and taking a database offline? : sql server DBA
1075Post New DB Administration Questions
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
internal architecture
what is the use of ocr?
What is dbcc? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What happens on checkpoint? : sql server DBA
what are the differences of where and if in SAS?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you find out if a table can be redefined?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
how can you record information about current session?
How do you trace the traffic hitting a sql server? : sql server DBA
what is a crs resource?