Monthly Archives: April 2008

Ongoing Lessons from the Cluster Lab

Posted on 10. April 2008 by Bennett

It’s been a while since I worked on my cluster lab. The first thing that I did was to tear down the old cluster and start over from scratch. The first lesson from this round of testing came when the … Continue reading →

Posted in Windows OS | Comments Off on Ongoing Lessons from the Cluster Lab

Getting HH:MM:SS value from Seconds

Posted on 7. April 2008 by admin

Here is another handy date manipulation function. This one converts the number of seconds, expressed as an int, into the HH:MM:SSS format SELECT CASE WHEN @seconds/3600<10 THEN '0' ELSE ” END + RTRIM(@seconds/3600) + ':' + RIGHT('0'+RTRIM((@seconds % 3600) / … Continue reading →

Posted in T-SQL | Comments Off on Getting HH:MM:SS value from Seconds

Stripping the time component from a datetime value

Posted on 7. April 2008 by Bennett

Here is a very simple and elegant way to strip the time component from a datetime value: CAST(FLOOR(CAST(@date AS float)) AS datetime) Written as a function: CREATE FUNCTION BareDate ( — Add the parameters for the function here @date datetime … Continue reading →

Posted in SQL Server | Comments Off on Stripping the time component from a datetime value

Moving

Posted on 3. April 2008 by admin

I originally blogged on Yahoo 360, but it is a lame duck, so I’m moving my postings over to WordPress.

Posted in Uncategorized | Comments Off on Moving

The IIS Metabase Explorer Rocks

Posted on 3. April 2008 by Bennett

Today I was reminded of something that I knew but forgot. The IIS Metabase Explorer for IIS6 (or MetaEdit for IIS 4 and 5) is a very useful tool. I needed to blow away an inheritable attribute of the HttpRedirect … Continue reading →

Posted in IIS | Comments Off on The IIS Metabase Explorer Rocks

Partition Misalignment can Cause Poor Performance

Posted on 1. April 2008 by Bennett

Here is an interesting Microsoft Knowledgebase article titled Disk performance may be slower than expected when you use multiple disks in Windows Server 2003, in Windows XP, and in Windows 2000. It explains how a partition misalignment can cause significant … Continue reading →

Posted in Performance, SQL Server | Comments Off on Partition Misalignment can Cause Poor Performance