http://www.sqlmag.com/authors/author/author/5777799/rsscomment/5777799en-USFri, 25 May 2012 09:17:19 GMTFri, 25 May 2012 09:17:19 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorWed, 19 Mar 2008 15:56:53 GMT
Very useful article and seems to fill my needs.]]>MichaelWed, 19 Mar 2008 15:56:53 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorTue, 04 Dec 2007 08:47:27 GMT
A piece of crap - it just doesn’t work - it won’t even make the objects much less actually do something.]]>johnTue, 04 Dec 2007 08:47:27 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorThu, 04 Oct 2007 10:25:19 GMT
DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES; the above will give you better results without a cursor]]>MikeThu, 04 Oct 2007 10:25:19 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorWed, 13 Apr 2005 14:54:10 GMT
The syntax error is easy to fix - just modify the select statements (select from o to something like select * --from o). I compiled everything,and the demo works great Anastasia]]>ANASTASIAWed, 13 Apr 2005 14:54:10 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorThu, 02 Dec 2004 08:56:25 GMT
Ditto. Errors in p_del_OBJECT_LIST_DATA limit the usefullness of the utility. I want to use it but make chages to use instead DBCC INDEXDEFRAG. Not knowing what the author was trying to do, means more time on my part. I would expect the listings in this Mag to work out of the box.]]>RALPHThu, 02 Dec 2004 08:56:25 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorTue, 23 Nov 2004 18:02:41 GMT
not only are there syntax errors in listing 1, but there are also errors in p_REINDEX_check in that it doesnt encapsulate the table names in braces to prevent it from erroring when a table has a space or period in its name.]]>JASONTue, 23 Nov 2004 18:02:41 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorThu, 28 Oct 2004 22:29:45 GMT
Very useful tool. But I am getting syntex errors when I implemented on production. DBCC REINDEX syntex error. If you know the fix please let me know. I’m lazy to fix on my own. ]]>RAJUThu, 28 Oct 2004 22:29:45 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorFri, 22 Oct 2004 04:18:12 GMT
Very useful idea, the syntax errors in the p_del_object_list_data procedure invalidate its’ usefulness. ]]>mselwayFri, 22 Oct 2004 04:18:12 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorWed, 13 Oct 2004 08:14:13 GMT
I was thinking of doing a similiar approach. One thing I do different is when a cluster index needs to be Reindex I do all the indexes on the table by not specifying the index name. I found the command runs quicker than if I just did the cluster index. The Profiler reports the read and write counts are higher but the duration is less.]]>DAVIDWed, 13 Oct 2004 08:14:13 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorWed, 06 Oct 2004 14:45:42 GMT
Oh yeah...Listing 1 does NOT show any delete statements, yet article says it is suppose to delete obsolete records.]]>LeoWed, 06 Oct 2004 14:45:42 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorWed, 06 Oct 2004 14:01:02 GMT
I am also getting this when executing Listing 2: Server: Msg 8145, Level 16, State 2, Procedure sp_add_job, Line 0 @SELECT_level is not a parameter for procedure sp_add_job.]]>LeoWed, 06 Oct 2004 14:01:02 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorWed, 06 Oct 2004 14:00:47 GMT
There appears to be a syntax error in Listing 1 ( line 11-12: SELECT FROM o FROM ... and another at line 23-24: SELECT FROM l FROM ... Should these be: SELECT * FROM ... on both incidences?]]>LeoWed, 06 Oct 2004 14:00:47 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorThu, 30 Sep 2004 17:24:53 GMT
Please specify the correct syntax for the stored procedure "p_del_object_list_data" in Listing 1. ]]>mjmclean Thu, 30 Sep 2004 17:24:53 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorhttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchorThu, 30 Sep 2004 09:51:03 GMT
There is an error in the listing 1 the stored procedure p_del_object_list_data is a select statement and not a delete as mentioned in the article]]>HenryThu, 30 Sep 2004 09:51:03 GMThttp://www.sqlmag.com/article/tsql3/automatic-reindexing#commentsAnchor