// archives

database

This tag is associated with 3 posts

Did you test that SQL?

By dlambert ⋅ May 27, 2011 ⋅ Post a comment

Although IT is a relatively young field relative to accounting or finance, I think a pretty fair number of people have picked up on some of the “big picture” ideas that drive modern development practices.  Whether you’re working with a waterfall process or a more agile process, for instance, most people understand that you just [...]

Data Smells

By dlambert ⋅ July 10, 2009 ⋅ One comment

Developers are familiar with “code smells” –the little signs you see upon superficial examination of code that lead you to fear deeper pathalogical problems.  Over time, many developers become pretty good at spotting these signs, and volumes have been written about how to address these problems once they’re detected. But code smells aren’t the only [...]

Table variables in SQL Server

By dlambert ⋅ February 19, 2009 ⋅ 2 comments

Working in SQL requires a mind-shift from procedural thinking to set-based thinking.  Although you can get SQL to operate one record at a time, it’s usually slower, and almost always painful to force SQL to work like that. One of the implications of set-based operations is that traditional single-value variables can’t quite handle many processing [...]

—