Browse by Tags

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...

The attached is the C# code that I used for generating the test results charted in my previous post . Note that for testing no generated script is actually persisted into a file by this program. The Script() method is applied, but the resulting script Read More...

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...

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...

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...

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 Read More...