Thomas LaRock wrote the following TSQL and it is amazingly informative.

-- This script will tell you when, where, what type of backup, how long it took, and who took the...

1. how to determine from the result of dbcc showcontig whether I have to reindex. - Index ID must be greater than 0 (0 means it is a heap). ...

Thank you all! As a followup, does a delete record take up more space in the transaction log than an insert and if so, is there any way to...

A server reboot is usually a sign of hardware failure, i.e. overheated processor, power supply, or even something even more simple.

Please review the event log for more information.

Like many of the posts here today, from those that have/are working from home, I tend to put in more hours while working from home. OCTOM's comment was how...

Gails answer is best, but if you want a specific article please review the following:

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Is SSIS installed?

You said management would not accept removing older data. Is this "older" data used regularly? Or, can you remove it to a new database called "DRIBS_Archive" and then take...

What version of SQL Server with SP are you running?

Please post the results of the following:

select @@version

Have you performed a migration from one SQL Server to a different SQL Server?

Can you run the following against the msdb database and verify subsystem dlls are pointing to the...

Are there any messages in the SQL Agent Log, SQL Server Log, Error Log files? Typically the SQL Agent Log will tell you precisely why.

Have you attempted to enable...

An annoying bug with SQL Server Express and multiple instances. You will most likely need to uninstall the second instance via command line. Take a look at the...

Have you put any thought in to rebuilding the Full-text catalog(s) prior to the backup job? It isn't a bad maintenance addendum to rebuild Full-text catalogs once a month...

Check the log files for any information.

Also, do you have "Auto restart SQL Server if it stops unexpectedly" and " Auto restart SQL Server Agent if it stops unexpectedly" checked?...

Dave said it best Google is your friend, one solution is in this article.

http://omaralzabir.com/a_significant_part_of_sql_server_process_memory_has_been_paged_out__this_may_result_in_performance_degradation/