http://www.sqlmag.com/authors/author/author/5622333/rsscomment/5622333en-USFri, 25 May 2012 08:17:37 GMTFri, 25 May 2012 08:17:37 GMThttp://www.sqlmag.com/article/tsql3/improving-the-index_evaluation_usp-stored-procedure#commentsAnchorTue, 06 Jul 2010 10:08:28 GMT
Both scripts refer to a table "Index_Evaluation_Map" which is droped if exist at the start but never created. I changed the last two lines to this.
select * --into Index_Evaluation_Map
from #mainindexmap
--select * from Index_Evaluation_Map
order by Database_Name, Type, Index_Name]]>CHRISTOPHERTue, 06 Jul 2010 10:08:28 GMThttp://www.sqlmag.com/article/tsql3/improving-the-index_evaluation_usp-stored-procedure#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/use-ssis-to-access-wmi-data-on-multiple-servers#commentsAnchorTue, 15 Dec 2009 09:00:29 GMT
Great article. I am in the process of implementing a similar solution but I am needing to read logs from a remote machine and I am having issue with security. I am not using NT authentication. Any insight would be appreciated.]]>AlanTue, 15 Dec 2009 09:00:29 GMThttp://www.sqlmag.com/article/task-scheduling/use-ssis-to-access-wmi-data-on-multiple-servers#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/use-ssis-to-access-wmi-data-on-multiple-servers#commentsAnchorMon, 02 Nov 2009 08:42:09 GMT
Great article... I haven’t dealt with SSIS very much and I was able to create and run this without any issue. Many Thanks!!]]>PaulMon, 02 Nov 2009 08:42:09 GMThttp://www.sqlmag.com/article/task-scheduling/use-ssis-to-access-wmi-data-on-multiple-servers#commentsAnchorhttp://www.sqlmag.com/article/tsql3/improving-the-index_evaluation_usp-stored-procedure#commentsAnchorThu, 09 Jul 2009 21:17:15 GMT
If the dblist cursor comes to an offline db, the proc fails. Suggest: declare @database_name varchar(500),@CMD nVARCHAR(MAX) declare dblist cursor for select name from master.sys.databases where name not in (’master’,’tempdb’,’model’,’msdb’,’distribution’) and state_desc = ’ONLINE’ and name = case when exists (select 1 from master.sys.databases where name=isnull(@i_DbName,’)) then @i_DbName else name end order by name open dblist]]>PaulThu, 09 Jul 2009 21:17:15 GMThttp://www.sqlmag.com/article/tsql3/improving-the-index_evaluation_usp-stored-procedure#commentsAnchor