Why we need to use secondry database file? though, we can do same work using primary database file also.
2 4809What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
RBS,
1 3034
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Explain microsoft sql server functions?
What is identity?
why would you call update statistics? : Sql server database administration
What are the essential components of sql server service broker?
Explain some stored procedure creating best practices or guidelines?
What is the difference between createstatement and preparedstatement?
Define model database?
Differentiate between a having clause and a where clause.
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is explicit cursors?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How do I find information about the install locations for the various instances running on a computer?
What is clr ddl trigger?
Can we add an identity column to decimal datatype?