How would you extract DDL of a table without using a GUI tool?
No Answer is Posted For this Question
Be the First to Post Answer
how can you process messages in order asynchronously?
What are the steps you will take, if you are tasked with securing an SQL Server?
Which autogrowth database setting is good? : sql server DBA
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the difference between dropping a database and taking a database offline? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
Explain what partitioning is and what its benefit is.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What purpose does the model database server? : sql server DBA
i had backup last manday.now i need back monday to now ..how do get backup?
what is the difference between hot backup n rman backup?