October Update to Rules-Driven Maintenance

Posted by merrillaldrich on SQL Blog See other posts from SQL Blog or by merrillaldrich
Published on Wed, 09 Oct 2013 23:19:00 GMT Indexed on 2013/10/17 22:08 UTC
Read the original article Hit count: 398

Filed under:

indexes

|

Maintenance

|

statistics

Happy Fall! It’s a beautiful October here in Minneapolis / Saint Paul. In preparation for my home town SQL Saturday this weekend, as well as the PASS Summit, I offer an update to the Rules-Driven Maintenance code I originally published back in August 2012 . It’s hard to believe this thing is now more than two years old – it’s been an incredible help as the number of databases and instance my team manages has grown. One enhancement with this update is the ability to set overrides for both Index and...(read more)

© SQL Blog or respective owner

Related posts about indexes

Stairway to SQL Server Indexes: Step 1, Introduction to Indexes

as seen on SQL Server Central - Search for 'SQL Server Central'
Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity… >>> More
When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

as seen on SQL Server Central - Search for 'SQL Server Central'
SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider? Check out this tip to learn more… >>> More
text indexes vs integer indexes in mysql

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I have always tried to have an integer primary key on a table no matter what. But now I am questioning if this is always necessary. Let's say I have a product table and each product has a globally unique SKU number - that would be a string of say 8-16 characters. Why not make this the PK… >>> More
SQL SERVER – Disabled Index and Update Statistics

as seen on SQL Authority - Search for 'SQL Authority'
When we try to update the statistics, it throws an error as if the clustered index is disabled. Now let us enable the clustered index only and attempt to update the statistics of the table right after that. Have you ever come across the situation where a conversation never gets over and it continues… >>> More
Macro doesn't work in the function.

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problems with following code: http://lisper.ru/apps/format/96 The problem is in "normalize" function, which does not work. It fails on the fifth line: (zero-p a indexes i) (defun normalize (a &optional indexes i) "Returns normalized A." (pragma (format t "Data=~A ~A ~A" a indexes… >>> More

Related posts about Maintenance

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
Tools to (privately) annotate/markup a website for maintenance

as seen on Super User - Search for 'Super User'
I've been tasked with updating a website. Rather than proofreading and updating each page (one at a time), I want to make a single pass over the entire website, marking graphics/images/videos that need to be rewritten, removed, or updated. I thought about taking screenshots, marking those up, and… >>> More
Activate site maintenance via RewriteCond -f check?

as seen on Stack Overflow - Search for 'Stack Overflow'
I thought about hitting a file via -f (i think it is) in a mod_rewrite RewriteCond, if the file exists, rewrite to maintenance page. I don't think the performance penalty should be too big, but maybe people had other experiences or objections on this idea? >>> More
Exam 70-448 - TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
The another exam I passed was 70-448 - TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. This exam covers Business Intelligence (BI) solutions development and maintenance on SQL Server 2008 platform. It was not easy exam, but if you study then you can do it. To get… >>> More
Oracle presents an upgrade tool for the E-Business Suite: Oracle Maintenance Wizard

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Vikki Pickard, Product and Development Manager for the Oracle Maintenance Wizard introduces a very useful tool that guides customers through E-Business Suite upgrades and the code line maintenance process. >>> More