Database Programming: The OPENROWSET Trick, Revisited

One of the most popular posts in the history of this little corner of the Internets is one from August, 2005, which describes a method for accessing stored procedure output in a SELECT statement which I’ve come to refer to as “the OPENROWSET trick.” On the occasion of this blog’s 750th post(!), I thought it…

6

What I Know Now: Ward’s Epistle to the N00bs

And I remember what she said to me How she swore that it never would end I remember how she held me, oh so tight Wish I didn’t know now what I didn’t know then Bob Seger, Against the Wind All you need is love Love is all you need John Lennon and Paul McCartney,…

11

As Spring Approaches, a SQL Blogger’s Thoughts Turn to Daylight and Baseball

As we progress towards the Ides of March, one of my best friends-who-I’ve-never-met, Jimmy May, notes our annual transition to Daylight Savings Time, in a post he generously concludes with a link to one of this very blog’s oldies but goodies. In his blog’s title, Jimmy humbly refers to himself as Jimmy May, Aspiring Geek. …

2

Database Programming: NULL and (NOT) IN Don’t Mix Well

Jens Suessmeyer is a Microsoft Consultant in Germany who frequently shares his useful techniques and insights both inside Microsoft and in the community at large.  In his latest post, he answers a colleague’s question with a simple yet thorough repro which proves the titular point. Here’s the money quote from Books OnLine: Any null values…

0

Database Programming Contest: Adam Machanic Throws Down

Never let it be said that Adam Machanic lacks style.. Adam left a comment on yesterday’s revisiting of the XML String Concatenation Trick, announcing his T-SQL Challenge: Grouped String Concatenation contest. Read Adam’s post to get all of the particulars for the event.  I hope to be able to play by Adam’s March 16th deadline…

0

Database Programming: The String Concatenation XML Trick, Revisited

UPDATED 27 February 2009 for spelling  I’ve got to pay more punctual attention to my comment pool.. RBarryYoung’s movingsql.com will be on my blog roll shortly after I get this posted (second attempt; first thwarted by a laptop hang.  I have suspended unit testing of SQLRAP 2.5 changes until I’m done.) for two very good…

6

Second Shot with a Side of Career Assist: Just What the Doctor Ordered

In light of the current state of the economy (not to mention recent news in my own back yard (I can still call it that since we continue, against our deeply held wishes, to own a house in Redmond)), I make it a point to count my blessings every day.  A loving and supportive family…

0

Database Programming: OBJECT_NAME Takes Two Parameters

This post is a cousin of sorts to last December’s post regarding the OBJECT_ID function.  I learned this from Dirk Gubbels when he sent me a follow-up email to the seasonal T-SQL he passed along (the posting of which spawned a small flood).  This “trick” is actually a SQL Server 2005 enhancement, so it will…

1

SINGLE_BLOB Size Limit: An Affirmation for Bert

Bert left a comment on this post pointing out a limitation of “the other OPENROWSET trick” (the one which loads an XML file into a single XML column): I tried this, but had an error because my XML file is 6gB. The SINGLE_BLOB seems to be limited to 2gB Bert is correct; fortunately, this is…

1

Linchi Shea Makes an Interesting Point About Hints

I had a couple of extra minutes today and found this post on Linchi Shea’s blog; I wanted to commend to all of you who’ve taken in the programming methodology and set-based thinking discussions in this little corner. While I disagree some with the point in the main post about views (JOINing views, to my…

2