Viewing 15 posts - 40,321 through 40,335 (of 49,571 total)
Please read the article I linked.
I don't want to guess as to your requirements and I would like to be able to test it before posting. Hence the request...
March 18, 2009 at 12:11 am
Joseph (3/17/2009)
avg_fragment_size_in_pages >= 8 AND fragmentation > 10 AND page_count >=1000
Regarding the fragment size, larger is better. The ideal is that fragment size = number of pages in index. Generally,...
March 18, 2009 at 12:08 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 17, 2009 at 3:51 pm
Of course. No point in rebuilding an index that isn't fragmented.
March 17, 2009 at 3:47 pm
Olga B (3/17/2009)
Gila, that's what I thought, but then the panic struck.
Don't panic 😉 http://www.sqlservercentral.com/articles/65804/
March 17, 2009 at 2:06 pm
On SQL 2000 run DBCC UPDATEUSAGE and check again. There were 'inadequacies' in the way SQL 2000 maintained the space-used metadata in the database.
March 17, 2009 at 2:04 pm
shnex (3/17/2009)
17 pages, but I have some with 2 pages or 34 that "respond" the same way to my script
Don't worry about fragmentation on tables that small. Fragmentation's only...
March 17, 2009 at 2:02 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic677775-146-1.aspx
March 17, 2009 at 1:59 pm
If you have a backup, restore from backup. It's when you don't have a backup that all sorts of tricks are needed to get the DB back.
March 17, 2009 at 1:55 pm
Why don't you buy the training kit? It's well worth the money spent.
March 17, 2009 at 1:54 pm
Stamey (3/17/2009)
Gail,Did you mean that at 50% your index would take twice the space on disk, rather than the table?
Depends what type of index. If it's the clustered index that...
March 17, 2009 at 1:50 pm
gdavidson (3/17/2009)
set @EventID = (SELECT...
March 17, 2009 at 9:24 am
Bob Hovious (3/17/2009)
"We're running out of time!"
Cannot run out of time. There is infinite time. You are finite, Zathras is finite. This is wrong tool.
March 17, 2009 at 9:22 am
Jack Corbett (3/17/2009)
GilaMonster (3/17/2009)
Bob Hovious (3/17/2009)
March 17, 2009 at 8:27 am
Chris Morris (3/17/2009)
March 17, 2009 at 8:26 am
Viewing 15 posts - 40,321 through 40,335 (of 49,571 total)