THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » T-SQL » sys2   (RSS)
  • SYS2 Scripts Updated – Scripts to monitor database backup, database space usage and memory grants now available

    I’ve just released three new scripts of my “sys2” script collection that can be found on CodePlex: Project Page: http://sys2dmvs.codeplex.com/ Source Code Download: http://sys2dmvs.codeplex.com/SourceControl/changeset/view/57732 The three new scripts are the following sys2.database_backup_info.sql sys2.query_memory_grants.sql ...
    Posted to Davide Mauri (Weblog) by manowar on February 13, 2011
  • “sys2” scripts are growing

    I’ve just released a new script, and now the sys2 scripts are reached the double-digit number: 10! http://sys2dmvs.codeplex.com/ The latest addition is the sys2.tables_columns scripts that helps me to detect which tables uses LOB column so that I can also check if that LOB data resides on a dedicated filegroup or not. Usually when I have such ...
    Posted to Davide Mauri (Weblog) by manowar on February 7, 2010
  • SYS2 DMVs on CodePlex

    I’ve just created a new project on CodePlex anmed SYS2DMVS, where I’ll put all my sys2 scripts so that they can be found and accessed more easily. Also it will more easy for me to maintain them, just a Check-In with SVN and that’s it :-). http://sys2dmvs.codeplex.com/ The scripts are growing in number, they are now 9, so I though that they ...
    Posted to Davide Mauri (Weblog) by manowar on January 18, 2010
  • sys2 scripts updated

    I’ve updated my “sys2” scripts with three 3 new scripts: sys2.objects_dependencies A wrapper around sys.sql_expression_dependencies that shows also related informations taken from sys.object table, like object name, object type and schema name of the referencing entity. sys2.objects_partition_ranges Shows information on partitioned ...
    Posted to Davide Mauri (Weblog) by manowar on January 7, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement