For those who want to play with the code, you can download it from here:

SQL Server and Custom Date Formats

charles.southey (3/23/2012)

---

If you want a commercially-supported CLR-based utility for this our SQLUtilities product includes a wide range of date formatting & parsing functions, as well as other useful date/time, string...

Thank you, David.

surreydude. (3/23/2012)

---

No mention of ISO date formats?

If the discussion is around how to present locale-specific date formats I would understand, but when converting dates an international standard must be one...

Thank you, Koen.

The BOL page for CONVERT is linked in the "built-in method so far" section. unfortunately hyperlinks are not easy to spot both on the forums and on the...

Just to add my $ .02, one hour is still a very long time, unless you're moving 1TB of data.

Are you sure there's no tuning opportunity in that code?

If it is configured to run as a service, you could set up the service to restart when it fails.

You can find that setting on the service properties, "Recovery" tab...

You could use a table variable to store the "split" values and join it to your table:

-- SETUP. When posting on the forums you'd better include a table definition like...

BACKUP is not a blocking operation. It consumes CPU and I/O and could slow down the instance, but not block other processes.

Paul Randal has a nice blog post on Backup...

You could split the street number / address parts into separate computed columns and create indexes on those columns.

This needs changes in the application, though.

FTI seems to me a bit...

Sorry to say that, bu I would have left it with the temporary tables, unless performance was not acceptable.

Is there a particular reason why are you merging everything in a...

You could try to put some of that logic in views or iTVFs.

I recently wrote a blog post on how to deal with huge statements. You can find some tips...

Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1269385.aspx

L' Eomot Inversé (3/16/2012)

---

mtillman-921105 (3/16/2012)

---

Brandie, you are showing your terrific vocabulary. I love that you used the word "felicitations." It made me suspect that the root word was...

Oracle owns MySQL, but there's a community edition of the product that can be downloaded and used at no charge.

Oracle offers Standard/Enterprise editions and maintains additional tools/features on those versions.