How do you trace the traffic hitting a sql server?
What is an identity?
What do we have to check in database testing?
Why would you call update statistics?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How many types of triggers are there?
What are page splits?
What are different types of statements that are supported by sql?
Characterize join and name diverse sorts of joins?
Why would you use sql agent?
What are the different types of backups avaialabe in sql server 2005?
What is set nocount on?
What are the different types of upgrades that can be performed in sql server?
What does null mean?
What is the difference between truncate and delete commands?