Browse by Tags
All Tags » news » Set-Based Thinking ( RSS)
-
|
I’ve attached to this message a ZIP file of the scripts from the SQL Tricks: Insights from Microsoft IT presentation I’m giving in Barcelona this week . The tricks will be familiar to long-time denizens of this space, as they’ve all been discussed here...
|
-
|
Marc left a great question on a Pond's Laws post from July of 2006 : Hi, I have a flashcard system that randomly pulls a word from the database. I also have a testing module that allows a user to test him or her self on words. For each word the user...
|
-
|
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...
|
-
|
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 recent...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
-
|
TechEd Developers 2007 got off to a roaring start today, as nearly 3000 attendees and presenters flocked to the Centre Convencions Internacional Barcelona for the event. Today’s keynote was delivered by S. Somasegar , Microsoft’s Corporate VP of the Developer...
|
-
|
Consider this a coding tip for SQL Server 2000 (as well as a reason to upgrade), and kudos for the SQL Server 2005 development team. In SQL Server 2000, IF (SELECT COUNT(1)..) > 0 will process an entire table or index to complete the count, while IF...
|
|
|