(Arthur Fuller) A common SQL Server application requirement is to support searches based on one or more long strings. (In this article, we refer to anything with more than 20 characters as a long string.) Suppose that your front-end application wants to allow the user to supply two long strings; you
Other News
Set Functions: The DrillDownLevelTop() and DrillDownLevelBottom() Functions
(William Pearson) In this article, we will continue the examination of "MDX for drilling up and down" that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our sub-series, stating that it comprises an analytical
Take The Fast Train
(Rahul Kitchlu and Boris Bialek) On January 30, IBM announced the availability of DB2 Express-C, a no-charge DB2 you can use for development or production. You can even redistribute it as part of your own application bundle, part of an educational curriculum, or just to friends and colleagues (pleas
Learn and Predict
(Ron Hardman) We predict potential outcomes based on actions every day. If I speed in my car, I have a much higher likelihood of being pulled over by the police than if I observe the speed limit. Choosing a burger and fries every day at lunch rather than a more nutritious meal is likely to lead to p
Searching XML with XQuery
(William Brogden) XQuery is intended to be a language for stating queries into XML data sources that is concise, powerful and easy to use. Supporters draw a parallel between SQL for relational databases and XQuery for XML. Defining the XQuery language standard is still at the W3C Candidate Recommend
Learn to avoid the mutating table problem in Oracle
(Scott Robinson) Tables are everything to IT database managers in ERP database environments. The organization of database tables, their relationships, and the manner in which they are managed are a fair indicator of the overall quality of performance you can expect from the system.
LAMP lights the way in open-source security
(Joris Evers) The so-called LAMP stack of open-source software has a lower bug density–the number of bugs per thousand lines of code–than a baseline of 32 open-source projects analyzed, Coverity, a maker of code analysis tools, announced.
Perfect Partner for Web Services: Getting to Know XForms
(Craig Caulfield) HTML forms are one of the best-known techniques for gathering data from a user and submitting that data to a server. However, HTML forms are only simple tools and don’t natively support some of the features needed by current Web applications such as sophisticated data validation. A
The Perfect Search
(Penny Crosman) If you want to find out what Brad and Angelina are up to, Google is a great search tool. Type in the celebrity names and poof, you get a list of the latest stories about the Brangelina baby-to-be. But if you need a technical or business-oriented search, Internet-style search technolo
Oracle Faces Tougher Foes Than Google In Search
(Charles Babcock) Oracle has taken the plunge into enterprise search, an area that has businesses trying to strike a balance between improved information access and fears of employees viewing and disclosing sensitive data.