Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 39384

Refers to the set of SQL Server Management Scripts created and maintained by Ola Hallengren. Questions tagged with this tag should be about how to use the scripts or about how to resolve an issue with the script.

6
votes
Yes that is normal. See: Disk Space Requirements for Index DDL Operations When a new index structure is created, disk space for both the old (source) and new (target) structures is required in …
answered Feb 12 '18 by Tom V - Team Monica
3
votes
I don't think there is such an option, and you could submit a feature request (or a pull request) to Ola, but you can however submit a list of indexes that you want to exclude. For example if you pas …
answered Jul 12 '18 by Tom V - Team Monica
3
votes
Ola Hallengren's solution doesn't support Columnstore indexes for now. There is an outstanding feature request on his Github that hasn't been closed as wontfix so you might want to keep an eye on tha …
answered Aug 28 '18 by Tom V - Team Monica
11
votes
Yes, the script is intelligent enough. This is explicitly stated in the FAQ: How should I configure IndexOptimize for an Availability Group? Indexes can only be rebuilt or reorganized and st …
answered Oct 10 '17 by Tom V - Team Monica
7
votes
Yes, if you look at the documentation, you see that you can use the @indexes parameter to specify which indexes to defragment. You can use % wildcards in your object names and you can prefix them with …
answered May 2 '18 by Tom V - Team Monica
4
votes
If you are worried about index fragmentation (which really only matters if you are doing range scans off disk) but you are loading your data periodically during an ETL process I'm assuming you have yo …
answered Aug 3 '18 by Tom V - Team Monica