Un-Answered Questions { Databases }

How do you trace the traffic hitting a sql server?

616


What is an identity?

567


What do we have to check in database testing?

582


Why would you call update statistics?

579


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?

545


How many types of triggers are there?

570


What are page splits?

577


What are different types of statements that are supported by sql?

594


Characterize join and name diverse sorts of joins?

528


Why would you use sql agent?

732


What are the different types of backups avaialabe in sql server 2005?

620


What is set nocount on?

500


What are the different types of upgrades that can be performed in sql server?

689


What does null mean?

599


What is the difference between truncate and delete commands?

563