Thanks Lynn, Adam and Steve.

I have also been doing some reading on this.

From what I have read on web and as you have suggested, it seems that we would have...

DavidB (2/17/2009)

---

It really doesn't decide to put it in a datafile. Rather than me typing all this out, the following is from BOL and explains things pretty well;

Filegroups use...

Thanks friends, I will try the script.

It needs to be done over the weekend.

Regards

Is your log file also in the same drive?

Is 'Auto Shrink Database' setting is set to ON?

I took two more log backups at intervals of 8 hours and again tried to shrink.

Voila ! It worked. The logfile is just 500 MB now.

Thanks to everyone who replied.

Regards

The database is in FULL recovery model.

I took a look at the script mentioned by you.

It is using BACKUP LOG WITH TRUNCATE_ONLY.

I do not want to use the TRUNCATE_ONLY option....

Thanks for your replies.

I forgot to mention that before taking the log backup the used space in T-Log was 12.9 GB out of 13 GB.

After taking the log backup the...

Thanks tfoley, MJ.

I found a script in the scripts section of this site which helped me find out the indexes that were fragmented the most.

Then I rebuilt all the ones...

Sorry, forgot to mention that the largest table has around 31 million rows and smallest among top 20 has around 2 million.

Thanks Gail for the reply.

The largest table occupies around 35 GB after deletion.

Top 20 tables out of total (19000) are around 250 GB in total in size.

I am planning to...

Brilliant article Gail.

Crisp, concise, easy to understand and to the point.

You have good narration capability.

Any thoughts of writing a book on SQL Server? 😉

Regards,

RSingh

Thanks for the reply.

Here is the DDL for the important tables involved:

================================================================================

CREATE TABLE [dbo].[GL_Star_Facts2006](

 [AccountID] [nchar](20) NOT NULL,

 [BusinessUnitID] [nchar](20) NOT NULL,

 [CompanyNumberID] [nchar](20) NOT NULL,

 [DateID] [bigint] NOT NULL,

 [FactsDetailID] [nchar](20) NOT NULL,

 [FiscalYearID] [nchar](20)...

I have tried to tune this Query in Database Engine Tuning Advisor and it shows 0% improvement.

I have another question now:

How to reduce the number of processors licensed without re-installing SQL Server.

I was able to do this on SQL Server 2000 servers by going to Control...

Thanks Aaron and Sugesh.

This was really helpful.

Regards

RSingh