Question { 5185 }

What is a job?

Answer

A job is a scheduled work and the repeated things are won't
run manually which has to be run regularly when the agent
is started position It is important the job is run only
when the sqlserver agent is in the start position

Question { 16452 }

What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?

Answer

delete table gives the transactional log where as in
truncate it is not delete the total rows inthe table but
structure of the table has never changed after the
statement is executed it is roll back and the constraints
after the delete statement is remain same where as it is
not in the truncate statement

Question { SAIC, 23611 }

What is database replicaion? What are the different types
of replication you can set up in SQL Server?

Answer

Replication is a method of copying data from one database
to other database or one server to another

there are three types of replication

(1) transactional (2)snapshot (3) merge (4) logshipping and
in 2005 one more type is introducde which was called as
peer to peer replications