http://www.sqlmag.com/authors/author/author/5015670/rsscomment/5015670en-USFri, 25 May 2012 10:24:25 GMTFri, 25 May 2012 10:24:25 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorMon, 15 Mar 2010 09:29:45 GMT
Good info! Thanks for sharing this process! I’m definitely going to look into using this.

Quick question for Brian: is this process geared towards a specific version? I was assuming 2K5 and 2K8, but I have some 2K databases that could benefit from this as well. I guess the easy way to find out is to give the sample code a trial run against each version.

Thanks again!]]>TOWNSENDMon, 15 Mar 2010 09:29:45 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorMon, 15 Mar 2010 09:29:11 GMT
Good info! Thanks for sharing this process! I’m definitely going to look into using this.

Quick question for Brian: is this process geared towards a specific version? I was assuming 2K5 and 2K8, but I have some 2K databases that could benefit from this as well. I guess the easy way to find out is to give the sample code a trial run against each version.

Thanks again!]]>TOWNSENDMon, 15 Mar 2010 09:29:11 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorThu, 11 Mar 2010 14:33:51 GMT
A good read, and well-written code. Thank you for your contribution.]]>JennThu, 11 Mar 2010 14:33:51 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorWed, 03 Mar 2010 13:24:47 GMT
Did SQL Magazine get new owners in the recent past? They seemed better a few years ago.

]]>RonWed, 03 Mar 2010 13:24:47 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorWed, 03 Mar 2010 00:48:49 GMT
So disappointing: slow site, zip file not available]]>WilfredWed, 03 Mar 2010 00:48:49 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorTue, 02 Mar 2010 18:00:53 GMT
I get an error when I try to access the code. Anyone, anyone? SQLMag you disappoint me, again.]]>RomeoTue, 02 Mar 2010 18:00:53 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorTue, 02 Mar 2010 13:42:23 GMT
I don’t see the zip file at the top of the page. Is it me or this system?]]>RonTue, 02 Mar 2010 13:42:23 GMThttp://www.sqlmag.com/article/sql-server-2000/intelligent-stats-updater#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorFri, 05 Jun 2009 15:19:07 GMT
If you dont have time to manage defragmentation check out this video. http://www.youtube.com/watch?v=6KvAkdmcBqU]]>JEREMYFri, 05 Jun 2009 15:19:07 GMThttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorWed, 03 Jun 2009 12:56:33 GMT
Ok, I just did the math again, and it is possible to reboot a machine within 43 minutes. My mistake.]]>MarcosWed, 03 Jun 2009 12:56:33 GMThttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorWed, 03 Jun 2009 12:56:33 GMT
Ok, I just did the math again, and it is possible to reboot a machine within 43 minutes. My mistake.]]>MarcosWed, 03 Jun 2009 12:56:33 GMThttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorWed, 03 Jun 2009 11:26:12 GMT
More over, how to acomplish a 99,999% uptime in SQL Server? At some point, you will have to aply a patch, or something else that will require a reboot. I doubt a reboot will take less then 0,001% or your month up-time.]]>MarcosWed, 03 Jun 2009 11:26:12 GMThttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorhttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchorMon, 01 Jun 2009 00:19:14 GMT
You are so lucky guy. I applied it so very frequently accessed tables. Then, the cpu was too high could not the services long time after recompiie the sp, using these tables. The sp uses 45 tables & 450GB size of total tables to inner & outer joins. and, called 350/sec... I used alread the keep fixedplan hint. But, it’s not worth in this situations. How to avoid this worst activation?]]>GMon, 01 Jun 2009 00:19:14 GMThttp://www.sqlmag.com/article/sql-server-2005/rebuild-indexes-online#commentsAnchor