ooh it must have been realy early in the morning ....

this inline select performs only a sum, so no duplicates

btw, suppose your in-line-select returns more than one result ?

Wich one to pick ?

just a first idea, early in the morning :

SELECT @ProjectID, CSPD.EventID, E1.LeadTime

, isnull(( SELECT DATEADD( d, -SUM( E2.LeadTime ), @CustomerShipDate )

     FROM CompanySeasonProductTemplate AS CSPD2, Event AS E2

    ...

Thank you Scott for the assistance

All Italics-characters are copied from books online. The coloring was just to emphasise the pittfalls.

... When a database is deleted, the default database for any associated users is supposed to be set to Master. Looking at the sysxlogins table, this appears to have happened....

from BOL :

NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making a backup copy of it and truncates the log. This option frees space. Specifying a...

Books Online

http://www.sqlservercentral.com 

http://www.sql-server-performance.com 

try this :

BEGIN TRANSACTION           

  DECLARE @JobID BINARY(16) 

  DECLARE @ReturnCode INT   

  SELECT @ReturnCode = 0    

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1

 ...

- errormessages ?

- sql-errors ?

we only reboot when needed (upgrade) or when e.g. a plant's productionprocess is in maintenance, we take the change to check the server thoroughly, perform systems-maintenance and reboot.

Currently our longest...

maybe you can have a first glimp using DBCC INPUTBUFFER (spid)

Offcourse profiler will be your main analysis tool.

- did you take a look a the statistics ? (dbcc showcontig, sp_spaceused... )

- you might use QA to check the queries using the option "display estimated execution plan" and...

you can say that again !

truncate_only seemed so easy, but making the new fullbackup has been forgotten many times

so his master-backup was older than one month ??

Define new backup Schedules using sql-backups and using sqlagent.

BEGIN TRANSACTION           

  DECLARE @JobID BINARY(16) 

  DECLARE...

please give him some time, the updateusage and sp_updatestatst will also take some time, then reruning the queries and some analisys also need more than 15 minutes