1) Explain different types of BACKUPs avaialabe in SQL Server?

2) Given a particular scenario, how would you go about choosing a backup plan?

No indexes, table scans, missing or out of date statistics, blocking, excess recompilations of stored procedures, procedures and triggers without SET NOCOUNT ON, poorly written query with unnecessarily complicated joins,...

This error will appear, if you never registered the the computer by it´s

exact name, which you want to define as a subscriber (don´t define only the

IP adress!). The main database...

Yes,it should be enabled

DATALENGTH returns the length of the string in bytes, including trailing spaces. LEN returns the length in characters, excluding trailing spaces. For example,

SELECT

LEN('string'),

LEN('string '),

...

SQL Server Agent service account is not what xp_cmdshell running under in the cleanup scenario, another suspect will be

the SQL Server service account. In any case, you should be able...

msdb..sysjobsteps, msdb..sysjobs

Snapshot Agent must have full control access to the replication folder (by default: ...\Program Files\Microsoft Sql Server\ReplData), and the Distribution Agents and the Merge Agents must have read access. This...

The owner of the job (who is probably the user who created the job or who first set up replication) does not have the necessary permissions.

wrap all the statments into the string and after that execute it with exec()

Any time no problem. It will not effect the performance.

Table variables require less locking and logging resources than temporary tables, so table variables should be used whenever possible.

http://www.sqlservercentral.com/articles/Administration/installingandupgradingtosqlserver2005/1943/

Have you checked both the system event log (looking for hardware issues) and the SQL errorlog?

Cross joins - Cross joins return all rows from the left table, each row from the left table is combined with all rows from the right table. Cross joins are...