Why we need to use secondry database file? though, we can do same work using primary database file also.2 4809
What is difference between process and thread? Explain lazy writer funcationality.2 6113
What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
How to connect PK and FK?2 4187
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
what is an sql server?1 2760
How to swap the data of two columns in a table. both the columns containing varchar values.9 12486
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?