Browse by Tags
All Tags » news » Programming Methodology ( RSS)
-
|
Kyle Schoonover, a former colleague in MSIT, posed the following questions in a comment on October’s cross-version database attachments post : Ward, I'm currently working in MySQL and writing conversion scripts to convert a MySQL database to a SQL...
|
-
|
Binh Cao's customer left a comment on yesterday's post on global temp tables. Here's the money quote: My research confirms that global temp table does allow the plan to be shared among processes. However now we are forced to deal with the...
|
-
|
One of the great things about my involvement with the SQL Ranger community is that I occasionally hear from past Candidates asking for help with issues in the field. So it was earlier this week when Binh Cao, an MCS Senior Consultant II based in San Diego...
|
-
|
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...
|
-
|
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...
|
-
|
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 received an inquiry yesterday from Greg Husemeier, who I met when he came to Redmond for the SQL Ranger program. Greg asked a great question: I hope you don’t mind me running a quick programming question regarding order of operators as predicates...
|
-
|
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...
|
-
|
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...
|
-
|
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...
|
|
|