SQL Server - Alter Index reorg or rebuild to change fill factorCorrect value for fill factor for clustered indexes with surrogate identity keysHow to determine Read/Write intensive table from DMV/DMF statisticsWhy can't I rebuild some SQL Server indices?Running “Rebuild Index” maintenance plan with “Online indexing”Does index fill factor become meaningless on large tables?Rebuild index --> update statistics?Index reorganizing slow after index rebuild with MS SQLClustered index rebuild appears to do nothingRebuilding the Management Studio Index in SQL Server 2005MSSQL-Server: rebuild vs reorganize Index and Update Statistics
How can I most clearly write a homebrew item that affects the ground below its radius after the initial explosion it creates?
Was the output of the C64 SID chip 8 bit sound?
Implement Homestuck's Catenative Doomsday Dice Cascader
Should an arbiter claim draw at a K+R vs K+R endgame?
Can an Aarakocra use a shield while flying?
Winning Strategy for the Magician and his Apprentice
Is using haveibeenpwned to validate password strength rational?
Does Disney no longer produce hand-drawn cartoon films?
How does an ordinary object become radioactive?
How to build suspense or so to establish and justify xenophobia of characters in the eyes of the reader?
Payment instructions allegedly from HomeAway look fishy to me
How Can I Tell The Difference Between Unmarked Sugar and Stevia?
What makes an item an artifact?
How to tell your grandparent to not come to fetch you with their car?
What's the largest optical telescope mirror ever put in space?
How do I write "Show, Don't Tell" as a person with Asperger Syndrome?
Which comes first? Multiple Imputation, Splitting into train/test, or Standardization/Normalization
Trapping Rain Water
Movie about a boy who was born old and grew young
How would a aircraft visually signal "in distress"?
What can I, as a user, do about offensive reviews in App Store?
BGP convergence issue
Compiling c files on ubuntu and using the executable on Windows
What's the name of this light airplane?
SQL Server - Alter Index reorg or rebuild to change fill factor
Correct value for fill factor for clustered indexes with surrogate identity keysHow to determine Read/Write intensive table from DMV/DMF statisticsWhy can't I rebuild some SQL Server indices?Running “Rebuild Index” maintenance plan with “Online indexing”Does index fill factor become meaningless on large tables?Rebuild index --> update statistics?Index reorganizing slow after index rebuild with MS SQLClustered index rebuild appears to do nothingRebuilding the Management Studio Index in SQL Server 2005MSSQL-Server: rebuild vs reorganize Index and Update Statistics
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?
sql-server
edited May 21 at 13:50
yagmoth555♦
12.7k31842
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
add a comment |
If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?
sql-server
edited May 21 at 13:50
yagmoth555♦
12.7k31842
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
add a comment |
If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?
sql-server
edited May 21 at 13:50
yagmoth555♦
12.7k31842
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
If I change the fill factor of an index, to make the change effective do I have to rebuild the index using "alter index rebuild" or can I also use "alter index reorganise"?
sql-server
sql-server
edited May 21 at 13:50
yagmoth555♦
12.7k31842
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
edited May 21 at 13:50
yagmoth555♦
12.7k31842
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
edited May 21 at 13:50
yagmoth555♦
12.7k31842
edited May 21 at 13:50
yagmoth555♦
12.7k31842
edited May 21 at 13:50
yagmoth555♦
12.7k31842
12.7k31842
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
asked Sep 14 '09 at 13:17
SuperCoolMossSuperCoolMoss
1,0221019
1,0221019
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f65143%2fsql-server-alter-index-reorg-or-rebuild-to-change-fill-factor%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
add a comment |
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
add a comment |
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.
You must use rebuild. Reorganise simply removes unused space and does some page defragmentation.
answered Sep 14 '09 at 14:31
user3914
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
add a comment |
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
Thanks, though that was the case - good to get comformation :)
– SuperCoolMoss
Sep 15 '09 at 8:12
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f65143%2fsql-server-alter-index-reorg-or-rebuild-to-change-fill-factor%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
