Checking the health of indexes and refreshing statistics in an MS-SQL environment is a best practice.
https://ola.hallengren.com/ -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Wednesday, November 09, 2016 12:22 PM To: [email protected] Subject: Re: Do you rebuild your indexes every night or do you leave them alone. Life in a file server world compared to your data in a rdbms where you only get data through the api. I haven't reindexed a table in my SQL servers in probably 10 years outside of freeing up wasted pages after a purge of a company's transaction data we sold off. On Wed, Nov 9, 2016 at 5:18 AM, Ted Roche <[email protected]> wrote: _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/bn4pr10mb09131df1a793e999577a9e74d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
