I am sorry , but which value showed it ?

GilaMonster (9/13/2010)

---

Then what about the intermediate level ?

But the above DBCC results show that table is not fragmented and statistics are also updated ( from scan density value...

How did you get this from above first post ( from DBCC results)?

gprbobby (1/5/2010)

---

I need to run an insert query on a db which would insert millions of records in a table. The log file for the db is growing around 3GB...

bhaskar.mythili (9/14/2010)

---

Three months back, I had similar issues, I tried alot of combinations/options with DBCC SHRINKFILE but nothing works. I installed SP3 in our development server and tried DBCC SHRINKFILE...

That should be available in sql server log

It doesn't seem that this table requires any defragmentation.scan density is very much closer to 100% which...

Goto database properties( right click it) >> select "files" option >> see...

run the above DBCC command for any one...

it is very small table , you cant expect good defragmentation here , table less then 1000 pages ( as i mentioned in my first...

thanks , its working

POst its result also

SELECT avg_page_space_used_in_percent

,avg_fragmentation_in_percent

,index_level

,record_count

,page_count

,fragment_count

,avg_record_size_in_bytes

FROM sys.dm_db_index_physical_stats(DB_ID('Dbname'),OBJECT_ID('MediaService'),NULL,Null, null)

where index_id in (0,1)

@lowell

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'SqlNotification' ,

@recipients = 'bkumar@abc.com',

@subject = 'SQl 2008 email test',

@body =...

From c_c_ post

2 reason: Detach then copy to bigger drive and reattach...