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 » Scripts   (RSS)
Showing page 1 of 2 (18 total posts)
  • 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
  • Check Script

    Someone contacted me yesterday and said they were getting blocked when they tried to create a FileStream data column type. On investigation, I found they were Mirroring that database – and the two aren’t compatible. Which got me to thinking – it’s probably a good idea to make a “check script” as you investigate tacking on a new feature, column ...
    Posted to Buck Woody (Weblog) by BuckWoody on June 30, 2010
  • Backup Meta-Data

    I'm working on a PowerShell script to show me the trending durations of my backup activities. The first thing I need is the data, so I looked at the Standard Reports in SQL Server Management Studio, and found a report that suited my needs, so I pulled out the script that it runs and modified it to this T-SQL Script. A few words here - you need ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 30, 2010
  • PowerShell: Read Excel to Create Inserts

    I’m writing a series of articles on how to migrate “departmental” data into SQL Server. I also hold workshops on the entire process – from discovering that the data exists to the modeling process and then how to design the Extract, Transform and Load (ETL) process. Finally I write about (and teach) a few methods on actually moving the data. One ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 18, 2010
  • “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
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
  • Find the complete call tree for a stored procedure

    Would it be nice to print out the complete call tree of a stored procedure? By complete call tree, I mean the following:   ·              At the very top level, the call tree should identify all the procedures that are called ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 22, 2009
  • Looping over routines using sp_foreachroutine

    Of all of the undocumented stored procedures shipped with SQL Server, there are two in particular that I constantly use: sp_MSforeachtable and sp_MSforeachdb. These procedures internally loop over each non-Microsoft shipped (i.e. user-defined) table in the current database, or each database on the current server, respectively. During this loop, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement