SP4? He's running SQL 2005.

Books On Line?

"Script will Provide us about the person who is running query and from where and why it is slowing down your CPU".

Where's the "who" and "why"?

The Performance_Dashboard reports are very helpful. They do a good job of drilling down.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

In the properties of the SQL Server Agent, what is the "Alert System" setting for Mail Session. Enable Mail Profile should be checked.

Microsoft has MSDN articles on how to do this.

http://msdn2.microsoft.com/en-us/library/ms179530.aspx

How do you know that the data is already in the existing file?  Are you going to read this file back in and check for existence?  Unless this is an...

How about these questions?

Is this person holding back a project because of their lack of knowledge?

Is this person causing others to have an increased workload because they're performing extra work/rework?

Does...

What is the actual size of the database?  When a backup file is created, the size of the backup file will be the size of the actual data.  So if...

select

* from sys.configurations

configuration_id name value minimum maximum value_in_use description is_dynamic is_advanced

102 allow updates 0 0 1 0 Allow updates to system tables 1 0

sp_configure (BOL)

Function works:

create

function [dbo].[fn_Padd]

(

@FileIn int

)

returns

varchar(100)

as

begin

declare

@newnum as varchar(100),

@strLen as int,

@pad

You perform a file backup of the resource database.

http://msdn2.microsoft.com/en-us/library/ms190190.aspx

From the way it sounds, your database will be crawling in short time, so it will be down anyway as it will become unusable?  Whoever is the owner of the...

Ideally REBUILD is best, but it has negatives.  It does require 1.2 times of the space of the index's. It is transactional, so it is fully logged and locks the table. ...

The SQL Server Instance is clustered. Permissions wouldn't be lost on a failover, as the entire instance fails over to the other node of the cluster.  As mentioned earlier, it doesn't seem as though SQL...