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

after you load, did you run

use yourdb

go

dbcc updateusage(0) with count_rows

go

sp_updatestats

go

Even if you have autostats on, this is needed once in a while, espacialy after full loads or heavy delete/insert...

just my 2ct.

- Also in desaster cases, first make a copy of what you (still) have !

- What made you (all drp-actors) decide...

... The indexes and calculation procedures have not changed much  ....

Did you change clustering indexes ?

   they influence the actual storage order of rows at the datalevel

   and...

don't forget to download the awe-fix !

sql2k sp4 awe fix

- With sqlserver, you can revoke builtin\administators from the logins of your server. Be carefull with that, because it will need your services to use a windows-account ! Make sure...