I just noticed there are a lot of people from South Africa posting... My birthplace! I wish I was there right now!

Lol... excellent

Assuming ColumnName is the name of your column (and Col1 & Col2 are additional fields)...

Select Col1, Col2, Case

When CharIndex(' ', ColumnName) = 1 Then Substring(ColumnName, 1, CharIndex('...

I'd use SUBSTRING with CHARINDEX - Is a space char always what you are going to look for?

Sql 2005's integrated backup functionality is not going to be very fast - though your storage infrastructure is going to be the biggest factor impacting the speed of backups &...

It depends what you are trying to return - and what kind of operations are being processed in the CLR code.

Are you doing any updates/inserts/deletes?

Are the queries that are ultimately...

Hey Steve: If you are going to upgrade the drives you should buy them through Dell. I had a big headache when I found out that my PowerEdge 2650's require...

I had this issue with a VB project with over 1,000,000 lines of code! It was so SLOW!!!

After the patch - WOW - I can actually scroll down my project...

I have tried to setup a seperate partition on my main Dev. machine with Windows XP x64. Lets just say that got real ugly, real fast

I just setup a 64bit Sql Server 2005 (Standard Edition) with Windows 2003 (Standard Edition) on an HP DL385 2 x Opteron 280 (Dual-core) w/ 16GB RAM and 6 x...

Search the "SQL Books Online" for T-SQL references and info regarding "BACKUP"

I think the BOL that ship with 2005 have some pretty good examples (I could not find the info...

I setup an (internal) SQL 2005 x64 Std. Ed. on Windows 2003 x64 Std. Ed. (which, I think, supports UP TO 32GB of RAM) on:

HP Proliant 585

4x Dual-core AMD Opteron...

Even though the CORE parts of 64bit SQL 2005 are fully native 64Bit code, the SQL Studio tools run inside a virtual 32bit environment on 64bit Windows.