A Way Around "Binary Hell" in SQL Server

March 3 2010

Warning: this article may offend your religious feelings - sorry about that. All others: play loud!

What is Hell? According to the famous rock band AC/DC (yeah!) it "ain't a bad place to be". For many people, regardless of their confession, it's supposedly some kind of dark pit, nobody knows exactly where it is, but it ought to be used to stow away the bad guys and gals for eternity. Once in a while it might happen that one of its "inhabitants" shows up on the surface, causing nothing but trouble ...

About Jörg A.

Jörg A. Stryk has worked with Microsoft Dynamics NAV since 1997, version 1.20.

Being project-manager, consultant, administrator, developer or supporter on Microsoft partner-sites and NAV customer-sites, he has thoroughly explored nearly all areas of the application and its technology.

Since 2003 he is focusing on "Dynamics NAV & SQL Server Performance Optimization and Troubleshooting", founding his company "STRYK System Improvement" in 2006. As a freelance consultant, he is supporting Microsoft Dynamics partners and customers with their NAV/SQL projects worldwide.

His book "The NAV/SQL Performance Field Guide" (ISBN 978-3-8370-1442-6) is published in Europe, the United Kingdom and North America.

In recognition of his valuable participation in various NAV communities, he received the Microsoft award "Most Valuable Professional" (MVP) for MS Dynamics NAV in 2007, 2008 and 2009.

Visit Jörg Stryk at www.stryk.info or his BLOG http://dynamicsuser.net/blogs/stryk/

More about Jörg A.


kriki's picture

In stead of disabling the BLOB-field, better change the type to boolean. See for more info disabled BLOB field bug in NAV2009 webservices