No announcements
Found 650431 threads
-
4 VotesIdentifying cause of index fragmentation
Is it possible to identify when an index becomes fragmented or what causes the fragmentation?Answered | 4 Replies | 991 Views | Created by runnerpaul - Wednesday, November 16, 2016 8:01 AM | Last reply by Naomi N - Wednesday, November 16, 2016 1:17 PM
-
0 Votes
Index Fragmentation
This fragmentation might be caused by fragmentation within the database file(s), or because the database files themselves are not ...Answered | 6 Replies | 5533 Views | Created by Reddy Balaji C - Tuesday, August 3, 2010 10:22 AM | Last reply by Raoul Illyes - Tuesday, August 3, 2010 9:57 PM -
1 Votes
data file shrink causes *massive* index fragmentation
If Fill factor is not set properly it goes large and could cause Database size to grow big.Answered | 8 Replies | 5373 Views | Created by Ajay.G - Tuesday, July 31, 2012 6:43 AM | Last reply by Shanky_621 - Thursday, July 24, 2014 11:25 AM -
1 Votes
Relation of Index fragmentation with number of pages
Index Fragmentation: Internals, Analysis, and Solutions.Answered | 5 Replies | 1643 Views | Created by Chetan_DBA - Friday, May 29, 2020 2:14 PM | Last reply by Chetan_DBA - Monday, June 1, 2020 10:55 AM -
0 Votes
Fragmentation of Index occurring frequently
Fragmentation caused by inserts can happen if you have meaningless (semi)random index key, such as a uniqueidentifier.Answered | 10 Replies | 1961 Views | Created by Sri Charan - Friday, January 4, 2013 9:23 AM | Last reply by Gert-Jan Strik - Sunday, January 6, 2013 9:49 AM -
0 Votes
Index Fragmentation
In testing with dbcc ind after rebuilding a small index, it looks the non-leaf page is stored after the first 8 extents, and there's a gap after it, perhaps to ...Answered | 2 Replies | 1297 Views | Created by Andrew Pruski - Wednesday, November 20, 2013 4:26 PM | Last reply by Andrew Pruski - Tuesday, November 26, 2013 3:22 PM -
0 Votes
index fragmentation versus no index
Two indexes appear wortheless to me 1.Answered | 4 Replies | 1314 Views | Created by O.Ragain - Monday, January 11, 2016 4:58 PM | Last reply by Lydia Zhang - Tuesday, January 19, 2016 9:53 AM -
2 Votes
Index fragmentation
30 and reorganize whose fragmentation is between 10 and 30.Answered | 11 Replies | 1936 Views | Created by DavidsSql - Sunday, August 10, 2014 8:35 PM | Last reply by Shanky_621 - Saturday, August 16, 2014 9:34 AM -
2 Votes
What is index fragmentation
Hi, Just a quiet note - index fragmentation is not the root of all evil.Answered | 2 Replies | 11325 Views | Created by Andrea Caldarone - Friday, February 24, 2012 4:12 PM | Last reply by Zoltán Horváth - Friday, February 24, 2012 5:35 PM -
0 Votes
Large Index Quickly Fragmented
Doing so may cause degraded performance or excessive memory consumption during these operations.Answered | 22 Replies | 5744 Views | Created by Steven Trout - Monday, April 29, 2013 6:50 PM | Last reply by Ola Hallengren - Friday, May 3, 2013 5:50 PM -
0 Votes
Index Fragmentation
Hi Samnalla, The extent of the Microsoft SQL Server index fragmentation determines whether a fragmented database will be defragmented by ...Answered | 2 Replies | 9567 Views | Created by Garyreeds - Sunday, March 14, 2010 8:55 AM | Last reply by - Tuesday, August 3, 2010 2:20 AM -
0 Votes
Index fragmentation
Hello, If you are going to delete data from the table, I would suggest to disable the index before you delete, because for deleting the index has also to be ...Answered | 1 Replies | 6292 Views | Created by striker-baba - Monday, May 3, 2010 9:34 PM | Last reply by Olaf Helper - Tuesday, May 4, 2010 6:17 AM -
0 Votes
How to Identify Database Fragmentation in sql 2008
Hi RaghuMohan Have a ...Answered | 3 Replies | 10040 Views | Created by RaghuMohan - Friday, September 16, 2011 5:15 PM | Last reply by RaghuMohan - Monday, September 19, 2011 3:55 PM -
0 Votes
Rebuild only Fragmented Indexes
Hello, The script query all fragmented indexes with a fragmentation trashold of at least 10% and min. 2 pages.Answered | 5 Replies | 3491 Views | Created by coolguy123SQL - Tuesday, July 31, 2012 5:20 PM | Last reply by KevinNicholas - Wednesday, August 1, 2012 7:29 AM -
4 Votes
Index Fragmentation Issues
Hi Mike, You dont have to worry about fragmentation on an index where the pages are less than 1000 or so.Answered | 8 Replies | 5103 Views | Created by vahdam_mn - Tuesday, May 4, 2010 7:04 AM | Last reply by Lekss - Tuesday, May 4, 2010 10:35 PM -
0 Votes
Separating indexes and data reduces fragmentation?
It depends what "fragmentation" your DBA is referring to: When talking about index fragmentation, the answer is no, since index ...Answered | 1 Replies | 2794 Views | Created by Pedja Stojakovic - Monday, February 27, 2012 8:47 PM | Last reply by LMU92 - Monday, February 27, 2012 9:06 PM -
0 Votes
fragmentation & rebult or reg org indexes
Go with Ola's great script https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html Best Regards,Uri Dimant SQL Server ...Answered | 1 Replies | 530 Views | Created by Hemadribabu - Thursday, April 21, 2016 5:21 AM | Last reply by Uri Dimant - Thursday, April 21, 2016 5:51 AM -
0 Votes
Index fragmentation
How can i know index fragmentation in % in ms sql server 2008Answered | 2 Replies | 2915 Views | Created by Aronbisrat - Monday, January 16, 2012 6:46 AM | Last reply by Gert-Jan Strik - Monday, January 16, 2012 7:25 PM -
0 Votes
Index fragmentation was high
... and remember that if you don't have at least some 1000 pages in the index, the fragmentation level is irrelevant.Answered | 3 Replies | 1016 Views | Created by subu999 - Monday, September 22, 2014 3:23 PM | Last reply by TiborK - Monday, September 22, 2014 4:06 PM -
0 Votes
Index fragmentation script doesnt seem to be reducing fragmentation
http://sqlblog.com/blogs/kalen_delaney/archive/2008/02/28/fragmentation-revisited.aspx AMB ...Answered | 1 Replies | 5786 Views | Created by MrFlinstone - Monday, November 8, 2010 1:17 PM | Last reply by Hunchback - Monday, November 8, 2010 4:05 PM - Items 1 to 20 of 650431 Next ›
No announcements
