Skip to content
WordsOnTech
  • Home
  • MS SQL Server
    • SSRS
    • Always ON
    • Failover Cluster
    • Performance Tuning
    • Replication
  • AWS
  • Azure
  • Scripts
  • About Us
  • Join Us

Best practice

Ola hallengren Index maintenance – Optimal way to use it

September 1, 2021 by Nitin

This code will execute IndexOptimize stored procedure and will reorganize or rebuild indexes based on default fragmentation values ( i.e., 5 and 30% – rebuild). However, this will not update statistics as default set to null.

Share this:

  • Click to share on X (Opens in new window) X
  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on WhatsApp (Opens in new window) WhatsApp
  • Click to share on Pinterest (Opens in new window) Pinterest
  • Click to print (Opens in new window) Print
  • Click to share on Reddit (Opens in new window) Reddit
  • Click to share on Telegram (Opens in new window) Telegram
  • Click to share on Pocket (Opens in new window) Pocket
  • Click to share on Tumblr (Opens in new window) Tumblr

Like this:

Like Loading...
Categories MS SQL Server, Performance Tuning Tags Best practice, Index maintenance, indexes, Ola Hallengren

Recent Posts

  • Out of memory exception in SQL Server Management Studio (SSMS) while opening ‘restore database’ page March 7, 2024
  • Using Snapshot Replication for Schema Transfer/Refresh Only March 7, 2024
  • Cleanup Log-shipping configuration through TSQL March 7, 2024
  • Configure non-default PostgreSQL instance for automatic start on machine start in RHEL March 4, 2024
  • Código de error: 22903, texto: “Ya hay otra conexión ejecutando ‘sp_replcmds’ para la captura de datos modificados en la base de datos actual.” March 4, 2024

AlwaysOn Amazon Web Services AWS AWS CLI AWS EC2 CDC Cloud costs Commvault cost monitoring cost optimization AWS encrypted backup Encryption Error 912 error 3417 Error 15151 Error 20011 Error 22017 Error 22307 Error 22903 HIGH CPU USAGE High Memory Issue Index optimization Login Failed LogShipping MS SQL Server MS_SSISServerCleanupJob Ola Hallengren Performance Tuning PowerShell Replication Replication Jobs S3 script Security SQL Server SQL Server 2017 SQL server 2019 SQL Server Backup SQL Server hacks SSIS_hotfix_install TDE TLOG Backups TSQL wait statistics Wait types

© 2025 WordsOnTech • Built with GeneratePress
%d
    We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok