Ola Hallengren adds STATISTICS support to his solution

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Mon, 13 Dec 2010 19:56:00 GMT Indexed on 2010/12/16 4:15 UTC
Read the original article Hit count: 369

Filed under:

fragmentation

|

index maintenance

|

Maintenance Plans

|

statistics

Last week, Ola published a very useful update to his Backup, Integrity Check and Index Optimization scripts : the solution now supports updating statistics. There are several options, such as only updating when the data has been modified and using the RESAMPLE and NORECOMPUTE options. An example call: EXEC dbo.IndexOptimize @Databases = 'USER_DATABASES' , @FragmentationHigh_LOB = 'INDEX_REBUILD_OFFLINE' , @FragmentationHigh_NonLOB = 'INDEX_REBUILD_ONLINE' , @FragmentationMedium_LOB = 'INDEX_REORGANIZE_STATISTICS_UPDATE'...(read more)

© SQL Blog or respective owner

Related posts about fragmentation

How to implement web cache: internal fragmentation VS external fragmentation

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there: I come up with this question when play with Firefox web cache: in which approach does the browser cache a response in limited disk space(take my configuration as an example, 50MB is the upper bound)? I think two ways can be employed. One is cache the total response object one by one, but… >>> More
What Does Fragmentation Do to Storage Network Performance?

as seen on Internet.com - Search for 'Internet.com'
Some say fragmentation introduces serious performance bottlenecks, others disagree, and everyone seems to have a strong opinion. >>> More
Keep Your SQL Server Indexes Fragmentation Free

as seen on Internet.com - Search for 'Internet.com'
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script. >>> More
Of Android and the Fear of Fragmentation

as seen on Internet.com - Search for 'Internet.com'
<b>The H Open:</b> "Glyn Moody takes a look at the state of Android, at the worries that the platform is fragmenting and why it isn't a bad thing." >>> More
How Virtualization Exacerbates Fragmentation

as seen on Internet.com - Search for 'Internet.com'
Hard-Core Hardware: Disk fragmentation is a significant problem for many data centers. Virtualization only makes it worse. Find out what steps you can take to mitigate it. >>> More

Related posts about index maintenance

NTFS Corruption: Files created in Linux corrupted when Windows Boots

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I'm getting some file loss and corruption on my Win7/Ubuntu 12.04 dual boot setup. I have a large shared NTFS partition. I have my Windows Docs/Music/etc. directories on that file and have the comparable directors in Linux setup as a sym. link. I'm using ntfs-3g on the linux side of things to… >>> More
Covering Index versus Clustered Index (Database Index)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm working on a database system and it's indexes, but I'm having a really hard time seing the clear difference between a covering index and a clustered index. I've googled my way around but hasn't got a clear cut answer on: What is the differences between the two types of indexes When do… >>> More
SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

as seen on SQL Authority - Search for 'SQL Authority'
Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation;… >>> More
SQL SERVER Force Index Scan on Table Use No Index to Retrieve the Data Query Hint

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Recently I received the following two questions from readers and both the questions have very similar answers.Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this?Question 2: Currently my table uses clustered index and does seek operation;… >>> More
htaccess code for maintenance page redirect

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I set up a maintenance page that I could enable through an htaccess file. The html file is located in a folder called "maintenance". The html file has some images in it. However, visitors to the page see no images, even though I added a line to allow them. If I try to visit an image in the browser… >>> More