http://www.sqlmag.com/authors/author/author/5263956/rss/5263956en-USFri, 25 May 2012 10:57:06 GMTFri, 25 May 2012 10:57:06 GMThttp://www.sqlmag.com/article/scripting/filtering-dml-statementsFiltering DML Statements]]>Shaunt KhaldtianceMon, 14 Dec 2009 00:00:00 GMThttp://www.sqlmag.com/article/scripting/filtering-dml-statementshttp://www.sqlmag.com/article/tsql3/stored-procedure-retrieves-information-about-partitioned-tablesSQL Server Management Studio (SSMS) doesn’t have a GUI that lets you easily obtain information about partitioned tables. Here’s a stored procedure that helps fill this gap.]]>Shaunt KhaldtianceThu, 03 Sep 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/stored-procedure-retrieves-information-about-partitioned-tableshttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packagesStoring SQL Server Integration Services (SSIS) packages under a well-defined folder structure in msdb is advantageous, but getting them there can be a hassle. Here’s a solution that does all the work for you.]]>Shaunt KhaldtianceTue, 12 May 2009 00:00:00 GMThttp://www.sqlmag.com/article/tips/easily-import-and-export-ssis-packageshttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-engineLooking for an object in a SQL Server instance without knowing the object’s exact name and the database in which it resides can be time-consuming. Here’s a T-SQL stored procedure that will make your seach much quicker.]]>Shaunt KhaldtianceThu, 09 Apr 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/need-to-find-an-object-but-you-don-t-know-its-exact-name-try-this-search-enginehttp://www.sqlmag.com/article/tsql3/track-database-disk-space-usage-on-a-granular-levelThe SpaceUsedAnalyzer stored procedure provides detailed information on how much space is being used by tables and their indexes so that you can manage disk space more efficiently.]]>Shaunt KhaldtianceThu, 30 Oct 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/track-database-disk-space-usage-on-a-granular-levelhttp://www.sqlmag.com/article/tsql3/evaluate-index-usage-in-databasesHere’s a T-SQL stored procedure that you can use to identify tables without indexes, indexes that aren’t being used, and indexes that aren’t being used efficiently.]]>Shaunt KhaldtianceMon, 29 Sep 2008 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/evaluate-index-usage-in-databases