Aries Manlig

  • Interests: Nature and Mystic Science

SQLServerCentral Article

Think Twice Before You Convert

Have you ever lost data when using CAST or CONVERT in T-SQL? There is an interesting behavior that probably has caused problems for quite a few people, and one you should be aware of. New author Aries J. Manlig brings us a look at this documented, but mostly unheard of behavior.

3.33 (3)

2005-12-22

10,916 reads

Blogs

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Do Full Backups Break Log Shipping?

By

TLDR: Nope. Keep on doing your full backups. Make sure that any databases you...

Daily Coping 15 Oct 2021

By

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

Read the latest Blogs

Forums

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

How to remove data and index fragmentation in a table

By 892717952

The picture is showing the results that I used sp_spaceused for OldTable and NewTable,...

Database Recovery but DB is 7GB and log file is almost 3

By Vector

I have had a server crash and although I was able to recover the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers