How to truncate a table first before running a package?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a group function explain with an example?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is sorting and what is the difference between sorting and clustered indexes?
what is diffence between replicaion and logshipping?
What are the purposes and advantages stored procedure?
what is integrated security (SSPI). why we use in the connection string?
Anyone please explain me the concept of Serialization?
what is the system function to get the current user's user id? : Sql server database administration
What is mean by candidate key?
What are ddl triggers and types of ddl trigger?
How to enable tcp/ip protocol on a sql server?