Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)

TOP, ORDER BY, and Non-Unique Columns

One of the comments I accidentally deleted earlier this afternoon posed the following question (paraphrased): I understand that TOP with ORDER BY makes no sense, but what about when I use different values for TOP and I ORDER BY a column that has duplicate

Ack! I Just Deleted Four Comments Accidentally!

If you've left a comment here since June 4th, please repost it with my thanks and apologies. I tried to do a bulk approval and I did a bulk deletion by mistake. One of them was a question about TOP with ORDER BY that I'll attempt to reproduce in a few

Database Programming: Operator Precedence in DTS is a Matter of Inheritance

This post will (hopefully) close a thread which runs here and here . When we last addressed this issue, I mentioned that an answer to the operator precedence question for DTS raised by Scott R. would depend on either my research or the kindness of others.

Database Programming: Operator Precedence In SSIS

This morning's post on Operator Precedence was a little misleading, as Scott pointed out in his comment: The example expression highlighted in green above (A <> 0 AND B / A > 1) is said to evaluate differently in SQL 2000 and SQL 2005, but I

Database Programming: Operator Precedence In SQL Server

[UPDATED 9 May 2008; the information presented doesn't exactly answer Greg's question. There's an update here ; and DTS is discussed here ] I received an inquiry yesterday from Greg Husemeier, who I met when he came to Redmond for the SQL Ranger program.

Two Pieces of Technical News from Kalen

Kalen Delaney has one of the most consistently informative SQL Server blogs in all of the Internets, and unless I miss my guess, it was also she who left the first of the very supportive comments I've received in the wake of my recent series of personal

Tech·Ed North America 2008 Developers Update/See You Next Week

The last couple of days have certainly had a particular orientation.  In addition to booking my arrangement for tomorrow night's trip to New York, today I booked my trip and accommodations in Orlando, and I received my speaking schedule last week. 

See You At Microsoft Tech·Ed North America 2008 Developers!

Happy news this week that I'll be traveling to Orlando, Florida the first week of June to attend and present at Microsoft Tech·Ed North America 2008 Developers June 3-6 at the Orange County Convention Center . I'll be revisiting the three presentations

Database Programming: The String Concatenation XML Trick, Finalized

It's an especially Good Friday when we can close the loop on a technical conversation, and I believe that our modifications to The Technique That Lance Found , also discussed here and here , are complete.  Scott Whigham left a comment on the most

Database Programming: The String Concatenation XML Trick, Sans Entitization

When last we checked in on The Technique That Lance Found , Adam had noted that the method entitizes XML special characters, a state of affairs which limits its utility somewhat.  I tried to leverage Tony Rogerson's technique , which Adam passed

Another Word On For-Fee Aggregators

One more post before I turn in.. Blogging is about passion and community, which may well be two sides of the same coin.  Our passion makes us a community.  Even though I don't read the output of my fellows in the SQL Server blogosphere nearly

Database Programming: The String Concatenation XML Trick Revisited (Or, Adam Is Right, But We Can Fix It)

A find shared by one friend leads to correspondence from another.. The redoubtable Adam Machanic left a comment on The Technique That Lance Found which points out that special XML characters in a string will get entitized. As usual, Adam is correct. If

Database Programming: The String Concatenation XML Trick

Courtesy of my good friend and once-and-always colleague, Lance Larsen, who writes: I recently ran into this little trick. Joining two tables having a one-to-many relationship and stuffing a set of column values from the many side into a single column

Yet Another Blog You Should Check Out

The comment space for yesterday's rant about the web site that's charging for access to MSDN and TechNet blog content is busier than any has been for awhile.  I also got this email via the contact mechanism on the blog: I was just about to ask you

Are You Paying To Read This Post? You Don't Have To!

In the age of the blog, it may well be that republishing is the sincerest form of flattery. The same RSS technology that many of you use to read the blog through wonderful rollers like this one also can be turned to far more nefarious purposes. I'm going
More Posts Next page »
 
Page view tracker