Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: May 2011

Shuttle Endeavor last mission STS-134: I felt the shockwave

I witnessed a piece of history today at 8:56am; the last voyage of shuttle Endeavor on its STS-134 mission. It was truly an amazing experience that will I will always remember. I was able to secure a spot across the Indian River about 12 miles across the Kennedy Space Center… Read more

0 comments, 345 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 16 May 2011

T-SQL: Identifying, inserting and removing spaces in strings

Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.

For example, you may want to show customer full names  by concatenating the columns that hold the different parts of customer names like FirstName, MiddleName, and LastName, separating each name… Read more

0 comments, 1,727 reads

Posted in Business Intelligence & SQL Server Decaffeinated on 11 May 2011