THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Scripts   (RSS)
Showing page 1 of 2 (11 total posts)
  • Reading temporary table from another session

    It happens to me at least once a week – I want to check progress of some heavy script that runs in chunks over big dataset and find out that it writes intermediate data to temporary table only. Last time it happened 3 days ago when I wanted to analyze 50GB trace table on my notebook. I wrote a script that was taking 200 thousand rows at a time, ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on March 1, 2012
  • 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: Source Code Download: 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
  • Viewing how much memory is used by not reused query plan

    One interesting observation that may help developers get convinced that they should parametrize query and that they must check that the ORM they use does it correctly is show how much memory can be wasted by plans that cannot be effectively reused. The following query can help on this: with cte as (     select ...
    Posted to Davide Mauri (Weblog) by manowar on July 23, 2010
  • “sys2” scripts are growing

    I’ve just released a new script, and now the sys2 scripts are reached the double-digit number: 10! 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 :-). 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
  • Partition Details Custom Report - enhanced

    Recently my fellow friend and colleague Yoni Nakache drew my attention to the nice custom report which can save valuable time to any DBA - it returns number of rows per partition along with partition boundaries and filegroup data. The rdl can be found here at Codeplex. What was definitely missing is space usage information - reserved / used space ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on July 7, 2009
  • Geek City: Too Many Columns!

    As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create a table with LOTS of columns. First of all, you're probably aware of the new SPARSE column feature that allows you to have up to 30,000 columns in a table!  I did some testing with sparse columns, but just today I realized I ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on September 20, 2008
  • Partitioning by GUID

    Recently I had to use GUID (Global Unique Identifier) as primary key in order to ensure cross-server uniqueness. In many cases surrogate key (some sort of concatenation between server id and intra-server identity) would give a better performance but in my case due to application requirements surrogate key wasn't an option. Next step is ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on June 10, 2008
  • Have your database ever been backed up?

    Recently I've been asked by one of my clients to write a simple script that would find out whether particular database had ever been backed up (full backup). The reason for a requirement was semi-automatic application which would enable end users to manage backup activity including manually backup transaction log - not via Management Studio but ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on March 1, 2008
1 2 Next >
Privacy Statement