What the different components in replication and what is their use?
What is the difference between truncate and delete commands?
What is the use of for clause?
What are the methods used to protect against sql injection attack?
What samples and sample databases are provided by microsoft?
How to change a login name in ms sql server?
Explain active/passive and active/active cluster configurations?
What is the osql utility?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
What is sql server replication? : sql server replication
what is call by value & call by reference ?