How to truncate a table first before running a package?
What is sql server replication? : sql server replication
What is a trigger? Why we need it?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
The Difference between 'Count' and 'Count(*)'
Do you have any idea about the tcl commands?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What are locks in sql?
Where is localdb stored?
Explain the use of containers in ssis and also their types?
What is a Join in SQL Server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Define left outer join in sql server joins?