Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Thursday, June 26, 2008 5:30 PM

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
Posted by Ward Pond | 1 Comments
Thursday, June 26, 2008 4:15 PM

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
Posted by Ward Pond | 0 Comments
Tuesday, April 15, 2008 5:30 PM

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. 
Posted by Ward Pond | 0 Comments
Wednesday, March 26, 2008 10:45 PM

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
Posted by Ward Pond | 0 Comments
Friday, March 21, 2008 7:15 AM

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
Posted by Ward Pond | 3 Comments
Tuesday, March 18, 2008 5:15 PM

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
Posted by Ward Pond | 3 Comments
Saturday, March 15, 2008 1:15 AM

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
Posted by Ward Pond | 0 Comments
Saturday, March 15, 2008 12:30 AM

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
Posted by Ward Pond | 4 Comments
Thursday, March 13, 2008 12:00 PM

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
Posted by Ward Pond | 4 Comments
Tuesday, March 11, 2008 2:45 PM

Don't Forget! SQL Server 2008 Web Chat On Thursday, March 13

I wanted to mention this one more time, since my previous post on this topic suffers from a cryptic title.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008. The
Posted by Ward Pond | 0 Comments
Friday, March 07, 2008 6:45 PM

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
Posted by Ward Pond | 0 Comments
Thursday, March 06, 2008 8:15 PM

SQL Server 2008 February CTP Scheduled For March 13

Forwarding along a nugget that my inbox served up.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008. The web chat starts here at 11 am Pacific Daylight Time on
Posted by Ward Pond | 1 Comments
Thursday, March 06, 2008 8:00 PM

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
Posted by Ward Pond | 6 Comments
Wednesday, February 20, 2008 9:15 PM

An Answer For Spazecaze: A Reasonable Method To Implement User Defined Fields

Spazecaze discovered a February, 2006 discussion of order of operations and poses the following question in its comment area : So how would you go about designing a database that allows for end user defined fields? For instance, a system is built to allow
Posted by Ward Pond | 0 Comments
Wednesday, February 20, 2008 8:45 PM

CTP 6 of SQL Server 2008 Is Now Available For Download

The latest CTP of SQL Server 2008 is available for download at the Microsoft Connect website, here . The list of new features in this release is pretty impressive: Progress-Based Management: policy violation alerts, policy import, running and evaluating
Posted by Ward Pond | 0 Comments
More Posts Next page »
 
Page view tracker