Thanks Nicolas.

I tried that on your advice but it didn't help.

I am interested as to what the float column is used for. Float is extremely imprecise. Adding columns of money amounts that are input to a float column will quickly...

I am not a giant fan of Index Tuning Wizard.

I usually look at the columns being joined and the columns used for filtering especially if the tables are over 1,000...

When restoring, did you use the MOVE keyword.

Here is an example from BOL:

RESTORE DATABASE TestDB

   FROM DISK = 'c:\Northwind.bak'

   WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',

   MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'

DAB wrote:

<<Let me re-iterate. Have you restarted the messenger service? >>

SUCCESS!

I just restarted the messenger service and ran my test job and it worked. I don't know how I...

I re-created the job and the notification still did not occur.

I tried xp_cmdshell in QA without success.

I set up a test job to execute xp_cmdshell on our sql2k and on our...

Allen and Julian,

Great stuff. I am going to drop the clustered index off my biggest two tables and re-create as non-clustered. I will schedule the Optimization job to run this...

The largest table is 83,000,000+ rows and 32GB.

There are not any binary, image, or text columns in this particular database.

Sorry SQLBill,

It really is the .mdf and .ndf files that contain 50% freespace. The .ldf grew somewhat and I expect it to shrink somewhat after the weekly backup.

But I am...

They are set to autogrow, unrestricted.

mljohn,

It is not the log file that is in question. The .mdf and the .ndf both contain 50% freespace.

If the index freespace is 10% and the data freespace is...

Shrink database when it grows beyond: 50MB

Amount of freespace to remain after shrink: 10% of the dataspace.

Unless someone has a script to do this....

I would probably generate scripts for all the tables, change the order, and create new tables either with new names or same names...

I run a DBMaint plan also that shrinks the index freespace to 10% and shrinks the database to 20% freespace. After it ran I checked and there was 3gb free out...