Good question, Igor. Enjoyed diging the inromation and basics.

Grant Fritchey (5/19/2014)

You can trace production too,...

You can check the status in Replication monitor

Check if any disk SAN issue.

You can use ALTER TABLE command.

Refer following link which might be useful:

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

There are no direct relation between master backup failed and rebuild master.

Have you checked why master backup is failing? Rebuilding the master is not a solution.

try DMV sys.dm_os_ring_buffers which might help you to get CPU info.

Interesting one, thank you Andy.

Your IT department should must have kept a copy of the software which you are using?

Can you post exact error while deleting records?

If you have doubt and server is not production you can enable trace for the specific database and check the activities going on?

For workload what are the things would like to monitor?

Also you can use following to trim result:

SELECT

SUBSTRING (CONVERT(nvarchar(15), GETDATE(), 6), 4,6) AS Month;

GO

Try something like this:

SELECT

CONVERT(nvarchar(30), GETDATE(), 6) AS Month ;

GO