Hi Steve,

Thanks. This is what I required.

Thanks Jerry.

GilaMonster (10/28/2008)

---

You need to have them in different plans because they have to run at different intervals. Remember what the...

Hi ALZDBA,

Thanks for the Code, I just run it on one of my production database, I got the following -

ObjectName, IndexID, indexName, statistics_update_Date

Some of my table are 'NULL' in...

Thanks. I add another maintenance plan for transaction log only.

Hi Gail,

Well, I have aware of that but as you know when you set the maintenance plan I selected for ALL DATABASES so that I can do all in one...

GilaMonster (10/27/2008)

---

Lowell (10/27/2008)

---

Second, I seem to remember the auto update of the statistics is based on a percentage of changes, i believe, say it's 1 percent of the sample size,...

Hi Gila,

Okay, I have untick the box for auto repair option. So do you think one of the Master,MSDB,TempDB got a error? It was failed becasue of that?

Shall I check...

Hi jsvensson

I used your VB Program to get the failed job on SQL Server but in some reason, I am getting the same result - For example -

I got 4...

Hi,

I switched my database from Full to Simple Mode. I don't need to backup the transaction log at the moment. I shrinked the database and rebuild will run after...

The page density looks a little low. Maybe consider upping the fill factor to about 75% and watch to make sure that the index doesn't fragment too fast. That will...

Hello Gila,

The table size has nothing to do with the transaction log. If the transaction log is not huge, then it's not a transaction log problem.

Transaction Log is...

Thanks Gila and Jeff.....

Leo

Hi Gila,

Sorry, I get back to you a bit late. I am not fully understanding about Transaction Log. Let say I switched my DB Model to 'SIMPLE'. I don't need...

Hi Jef and Gila,

Now I understand why I shouldn't shrink the Data file, I will take 'Shrink Database' Off from Maintenance Plan. All information you guys posted are very useful....