New cumulative Update Packs for SQL 2008: CU10 for RTM and CU7 for SP1

By tom on March 17th, 2010

Microsoft has released CU10 for SQL 2008 and CU7 for SQL 2008 SP1.

This makes the cumulative update table as follows:

Version Service Pack (SP) / Cumulative Update (CU)
10.0.2766.0 SP1 CU7
10.0.2757.0 SP1 CU6
10.0.2746.0 SP1 CU5
10.0.2734.0 SP1 CU4
10.0.2723.0 SP1 CU3
10.0.2714.0 SP1 CU2
10.0.2710.0 SP1 CU1
10.0.2531.0 SP1
10.0.1835.0 CU10
10.0.1828.0 CU9
10.0.1823.0 CU8
10.0.1818.0 CU7
10.0.1812.0 CU6
10.0.1806.0 CU5
10.0.1798.0 CU4
10.0.1787.0 CU3
10.0.1779.0 CU2
10.0.1763.0 CU1
10.0.1600.0 SQL 2008 RTM

 

To find out which version you are currently running, check out this blogpost.

Tom

Disk Alignment Check Utility & How to use diskpart to format your partitions with correct alignment

By tom on March 2nd, 2010

Paul Randal blogged here about how you can use diskpart and wmic to check if your partitions are correctly aligned. Calculating the offset is easy when using disks, but can be a little bit difficult if different partitions on a disk are used.

Tom Hirt of tcpdump.com wrote a great little tool which calculates the offset and displays whether or not your partitions are correctly aligned. You can download it here (registration required).

A screenshot of the tool showing Non-aligned partitions:

A screenshot of the tool showing aligned partitions:

If your partitions are not aligned, you can use diskpart to format them with correct alignment. Be careful, following steps erase the selected partition and reformat them. Make sure you have a backup of all your data before proceeding!

Open a command prompt

Type diskpart

Select the partition you want to align: select disk <DiskNumber> (you can check which disks are available by typing list disk)

Align the partition to 1024KB: create partition primary align=1024

Assign a drive letter to it: assign letter=<DriveLetter>

Now you can format your disks as usual, but with a correct offset. Please note that the procedure above only works for basic disks.

I hope this helps,

Tom