Browse by Tags

• Disk I/O
• Powershell
• Query Processing
• SMO
• Storage

• Add-Content and Out-File are not for performance

  When you write Powershell scripts and need to write a text file, you have a number of ways to accomplish that. The often suggested approach is to use cmdlets Add-Content or Out-File. Well, this is not news. But some may not notice that these cmdlets are Read More... Posted Monday, January 04, 2010 5:31 PM by Linchi Shea | 3 Comments Filed under: Performance, Scripts, Scripting, Powershell

• Performance impact: Speeding up SMO script generation

  Generating scripts through SMO can be as simple as walking down the database object tree and applying the Script() method to each scriptable object. Well, that is until you start to try it on a database that has a large number of objects (say a few thousands), Read More... Posted Sunday, December 13, 2009 6:18 PM by Linchi Shea | 7 Comments Filed under: Performance, Scripts, Scripting, SMO Attachment(s): MultiThreadSMO.GIF

• T-SQL Exercise: Simplest data-loading script to produce worst query performance – May 25th Update

  This is a quick update on the T-SQL exercise I posted a few days ago. The goal was to write a simple T-SQL script to generate and load 4,000,000 rows into a table so that the following query would produce the worst performance, i.e. take longest time Read More... Posted Tuesday, May 26, 2009 9:52 AM by Linchi Shea | 5 Comments Filed under: Performance, Scripts, Storage, Scripting, Disk I/O

• T-SQL Exercise: Simplest data-loading script to produce worst query performance

  Here is a T-SQL scripting exercise in case you have a few minutes to spare or are bored with whatever else you are doing. Objective The task is to write a simple T-SQL script to generate and load 4,000,000 rows into a test table. The objective is to make Read More... Posted Friday, May 22, 2009 4:21 PM by Linchi Shea | 19 Comments Filed under: Performance, Scripts, Storage, Scripting, Query Processing, Disk I/O