Why we need to use secondry database file? though, we can do same work using primary database file also.
2 7011What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
RBS,
1 4483
Can you type more than one query in the query editor screen at the same time?
Explain different backup plans?
What is blocking?
What are trace flags?
What are parameterized reports?
Explain about temporary stored procedure?
What is row-level compre?
How to fine-tune reports?
optimization techinques
What are the steps you must follow to hide sql server instances?
Can you please explain the difference between primary keys and foreign keys?
What will happen if a column containing char type data is changed to the nchar data type?
What happens to a statement batch if there is a compilation error?
What the different types of Replication and why are they used?
explain different levels of normalization? : Sql server database administration