Every year at PASS, I do the same thing. I hmm and haw over which sessions I want to go to, and I end up making some tough choices at game time.  This year I believe I'll be pretty busy, so my typical pie-in-the-sky view of how much I'll be able to attend just isn't going to pan out.  Instead, I have selected 5 sessions that I really ...

The behavior of column matching in subqueries is a little peculiar, to say the least.  If you've been bitten by this behavior once, you're unlikely to have been bitten a second time, but for some of us it just takes a while to sink in. This morning I wasted a good five minutes ''troubleshooting'' a query that wasn't working out the way I ...