// archives

SQL

This tag is associated with 2 posts

Conference packing list

By dlambert ⋅ October 5, 2009 ⋅ View Comments

Jeremiah Peschka just dropped a great post on prepping for an upcoming SQL Server conference: Random Thoughts for Enjoying the PASS Summit. Not going to PASS?  Don’t worry – this is a great general-purpose packing list.  Use this to prep for any trade show or conference. Thanks, Jeremiah. Tweet This Post

Table variables in SQL Server

By dlambert ⋅ February 19, 2009 ⋅ View 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 [...]

—