OK lets assume the fragmentation level is high and we really need re-building indexes every week then what is the solution ?

OK, NOW:

Can you explain how much important it is for a DBA to know about system administration/HW/Servers? and why ?

AND

Does this also mean that an IT person has to change/leave...

Nothing is jack of All AND nothing is master of ALL.

One has to be more specific and specialist in one area.

So i want to re-question that

DBA having good understanding of...

Yes simple will create problems. I tried with Bulk=Logged but even it do not work the way you want this.

What else you are doing when you are re-building weekly...

If it is backed up and still not reducing the size then try to shrink the log file manually upto your required size.

if it works then the problem is in...

Can you afford, changing the recovery model during the weekly index rebuild ?

In the weekly maintenance plan,

1. take full backup

2. Change the recovery model from full to simple

3....

OK Lynn.

So You are asking to emphasis more on understanding business and getting industrial functional knowledge. Along with your techinical skills, you must have a good understanding of a particular...

Yes i do understand what you are saying. However, question is

How effectively a DBA can lead an IT department with variety of IT skills people under him, as compared...

SQL Server 2005 has following default settings of model DB.

MDF = 3mb

LDF = 1mb

So infact question is not appropriate.

Can you tell what is this "Load delay period" ?

Can we configure this somehow, somewhere ?

The Log-shipping restore job runs successfull but last restored file is the which was copied 2 hours earlier. All jobs (backup, copy and restore) are set to run every 15...

Sometimes happens...

Any reason in your mind please ?

Yes it is set to zero.

I keep on running job manually several time. Job execute successfully but giving this information.

Skipping log backup file since load delay period has not expired...

My SSMS settings are

NON-XML = 65535

XML = Unlimited (and even tried with 2MB)

still getting empty row for these two:

select cast(('<root>'+REPLICATE(cast ('<abc/>' as varchar(max)), 100000) + '</root>') as XML)

select...

Same problem i can see on my server.

Delay restoring backup atleast = 0 Minutes

I have tried running the restore job manually several times but it is giving same message again...