Do you know exporting and importing utility?
No Answer is Posted For this Question
Be the First to Post Answer
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What are trace flags and mention a few common trace flags used with sql server?
What is key set driven?
What are the different type of replication in sql server?
Explain filtered indexes?
How do you use DBCC statements to monitor various aspects of a SQL server installation?
Why truncate is ddl?
What is difference between count (*) and count column?
Write a SQL queries on Self Join and Inner Join.
what are cursors? : Sql server database administration
Explain optimistic and pessimistic concurrency?