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 » Tools   (RSS)
  • 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
  • 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
  • Performance impact: file fragmentation and SAN - Part VI

    A script to fragment a test file Well, this post won't cover any actual test results and is not specific to SAN. But in the spirit of full disclosure, I've attached the script I used to control the fragmentation level of the test files mentioned in this series of posts. The script is written in Perl, but can be easily done in any ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 30, 2008
  • Finding Disk Partition Offsets Made Easy

    There were discussions on disk misalignment on this site. See my previous post on “Performance Impact of Disk Misalignment”, and Kevin Kline’s blog on “How to Improve Application and Database Performance up to 40% in One Easy Step”   But thanks to Jimmy May's PASS 2008 presentation on the I/O performance impact of disk partition ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 24, 2008
  • Did you know? Cloning is Legal (and Available in SQL Server 2005)

      I first heard about the possibility of database cloning way back in version 7.0 and thought it sounded like a great idea. Who wouldn't love to have a bunch of identical little databases running around, of smaller size and easier manageability? Cloning a database means creating a statistics only copy of it, so that you can examine ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 21, 2007
  • A Little Bit Scripting Saves the Day

    Recently, I got sucked into importing Excel sheets into a database. I had thought, well that's easy with a tool such as SQL Server 2000 DTS Import/Export Wizard or SQL Server 2005 Import/Export Wizard. Needless to say, the Excel import business ran into a snag. With the error messages from the wizard not being really helpful, I ditched the wizard ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on March 5, 2007
  • Parse the sqlio.exe Output

    Let's say you run sqlio.exe as follows: D:\sqlIO -kW -t32 -s30 -dE -o1 -fsequential -b8 -BH -LS Testfile.dat The output typically may look like this: sqlio v1.5.SG using system counter for latency timings, 1999980000 counts per second 32 threads writing for 30 secs to file E:Testfile.dat using 8KB sequential IOs enabling multiple I/Os ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on February 21, 2007
  • Msql -- A Little Wrapper Goes a Long Way

    Have you ever run into a situation where you'd like to search many of your SQL Server instances to look for a specific piece of information? Ideally, you should maintain an inventory database of all your SQL Server instances so that all you need to do is query that database. In case you don't have such an inventory (shame on you!) or the inventory ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 9, 2007
Privacy Statement