Keith

  • Interests: Triumph GT6 sportcars

Decimal2Text Measurement Function

This function is based on a script by Tim Dietrich (tim@timdietrich.us) named format_height.sql. His function took what he called a decimal representation of a measurement and formatted it as feet and inches. In reality the input value was just a measurement formatted to look like a decimal number but it was not a true decimal […]

2003-06-27

66 reads

Blogs

T-SQL Tuesday Retrospective #006: What about blob?

By

I am revisiting old T-SQL Tuesday invitations from the very beginning of the project....

Daily Coping 2 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Database Corruption, how to investigate root cause?

By

Introduction: In this article, we will discuss the MS SQL Server database corruption.  So, first, we...

Read the latest Blogs

Forums

How to mantain index in SQL and size of Database

By andre1992

Hi everyone, I'm trying to figure out how to manage the maintenance of the...

vbs failing

By Sailor

This vbscript for Excel that opens a pipe delimited file  is failing srccsvfile =...

SQL Server Load

By narayanamoorthy.a

Hi, The application team is pushing more than 7 lakhs records per day to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers