<![CDATA[Article Comments for Shaunt Khaldtiance]]>http://www.sqlmag.com/authors/author/author/5263956/rsscomment/5263956en-USFri, 25 May 2012 10:57:15 GMTFri, 25 May 2012 10:57:15 GMTEvaluate Index Usage in Databaseshttp://www.sqlmag.com/article/tsql3/evaluate-index-usage-in-databases#commentsAnchorMon, 04 Apr 2011 19:11:21 GMT
where is the 99985.zip file? I can’t find the link of that file. this will be useful one I think.]]>devesterMon, 04 Apr 2011 19:11:21 GMThttp://www.sqlmag.com/article/tsql3/evaluate-index-usage-in-databases#commentsAnchorEasily Import and Export SSIS Packageshttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packages#commentsAnchorTue, 13 Jul 2010 12:52:09 GMT
Hi Karen

Thank you very much for this article.
I am a bit green on SSIS. Could explain briefly how to install this solution?

Thanks in advance
Love your site
Al]]>AlfasuliTue, 13 Jul 2010 12:52:09 GMThttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packages#commentsAnchorTrack Database Disk-Space Usage on a Granular Levelhttp://www.sqlmag.com/article/tsql3/track-database-disk-space-usage-on-a-granular-level#commentsAnchorThu, 06 May 2010 17:49:15 GMT
I cant download the code from the ’Download Code’ link.]]>MalladiThu, 06 May 2010 17:49:15 GMThttp://www.sqlmag.com/article/tsql3/track-database-disk-space-usage-on-a-granular-level#commentsAnchorFiltering DML Statementshttp://www.sqlmag.com/article/scripting/filtering-dml-statements#commentsAnchorFri, 12 Mar 2010 08:42:35 GMT
This is a very shallow article, all it says is how to find hostname from sys.sysprocesses and use it to branch the code - which is not worth writing an article for. Am I missing something?
]]>vuht2000Fri, 12 Mar 2010 08:42:35 GMThttp://www.sqlmag.com/article/scripting/filtering-dml-statements#commentsAnchorStored Procedure Retrieves Information About Partitioned Tableshttp://www.sqlmag.com/article/tsql3/stored-procedure-retrieves-information-about-partitioned-tables#commentsAnchorTue, 03 Nov 2009 05:19:12 GMT
How to know column name(s) on which table is partitioned from partition related system views or functions ?]]>AnnaswamyTue, 03 Nov 2009 05:19:12 GMThttp://www.sqlmag.com/article/tsql3/stored-procedure-retrieves-information-about-partitioned-tables#commentsAnchorEasily Import and Export SSIS Packageshttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packages#commentsAnchorMon, 15 Jun 2009 14:19:30 GMT
The ~$cumentation.doc file was a hidden file that contained the actual article. It has now been deleted from the 101918.zip file. Sorry for any confusion. Karen Bemowski, senior editor SQL Server Magazine, Windows IT Pro]]>KarenMon, 15 Jun 2009 14:19:30 GMThttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packages#commentsAnchorEasily Import and Export SSIS Packageshttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packages#commentsAnchorFri, 12 Jun 2009 08:29:26 GMT
The "documentation" document in the package is not a valid Word document. Can you provide a useable documentation file?]]>JustinFri, 12 Jun 2009 08:29:26 GMThttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packages#commentsAnchorNeed to Find an Object But You Don't Know Its Exact Name? Try this Search Enginehttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorThu, 11 Jun 2009 11:22:07 GMT
This seems like a fancy way to retrieve catalog data. The INFORMATION_SCHEMA views can provide you with the same, or more, information. For example, if you were looking for all tables containing "access" in a database, you can try: select table_catalog as DBName, table_name as TableName, table_type as TableType from information_schema.tables where table_name like ’%access%’ If you needed to apply that query to all databases you can run it with sp_msforeachdb like this: exec sp_msforeachdb ’use ?; select table_catalog as dbname, table_name as tablename, table_type as TableType from information_schema.tables where table_name like ’%access%’’ With only slight modifications this can be applied to the other Information Schema Views for the type of object you are looking for. http://msdn.microsoft.com/en-us/library/ms186778.aspx rbs]]>RyanThu, 11 Jun 2009 11:22:07 GMThttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorNeed to Find an Object But You Don't Know Its Exact Name? Try this Search Enginehttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorWed, 20 May 2009 10:50:54 GMT
Nice script to have.]]>MarcosWed, 20 May 2009 10:50:54 GMThttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorNeed to Find an Object But You Don't Know Its Exact Name? Try this Search Enginehttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorTue, 19 May 2009 10:21:17 GMT
If you have a table CUSTOMER and have column CUSTOMER_ID you cannot search for the CUSTOMER_ID - column within TABLE.]]>TRACEYTue, 19 May 2009 10:21:17 GMThttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorNeed to Find an Object But You Don't Know Its Exact Name? Try this Search Enginehttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchorSat, 02 May 2009 10:38:54 GMT
for quick searches, there’s a free utility out there that does this, with a nice GUI too: http://www.nobhillsoft.com/DianaLite.aspx]]>YONISat, 02 May 2009 10:38:54 GMThttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engine#commentsAnchor