how can you implement fine-grained auditing?
What is the default fill factor value? : sql server DBA
1)how to Take Backup in sql server 2005 from Flash Drive
Explain the difference between a data block, an extent and a segment.
what is the use of recording information about current session?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
What are the different ways you can create databases in sql server? : sql server DBA
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?
What is dbcc? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
Can we take incremental backups in datapump?