(Richard Foote) As previously discussed, Linguistic Indexes can potentially be useful with case-insensitive searches and sorts.
Other News
11g SQL Performance Analyzer Rocks!
(Tyler Muth) There are a lot of myths and rules of thumb floating around about Oracle tuning: –Should I partition this table or not? –What partitioning scheme should I use? –What values should I use for OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING? –Should I regularly rebuild my
Table Data Partitioning in SQL Server 2005
In this blog post, we will cover a working example on data partitioning feature in SQL Server 2005. In subsequent posts, we will cover the different important aspects of data partitioning and the different types of partitioning that are available, their usage scenarios, things to look out for, etc.
SQL Server BI Marketplace – Headed for Consolidation (and stagnation?)
Featured Article(s) Using Oracle 11g Invisible Indexes This article describes how to use Oracle 11g’s new invisible indexes to prevent the accidental use of an index by a production system. We’ve Found Your SQL Assistant Just imaging having a good friend check your SQL code, help as you type, show you statement syntax and the like. This, versus having to […]
Managing SQL Server Updates: One Approach
SQL on Call Show Available Now The latest SQL on Call show is live now and you can watch it on the site – in today’s show Chris closes out the series of top 10 SQL Server thoughts about 2007. > Watch here Also available: [Watch] SelectViews, the SQL Server Show – Keeping up with technology, Microsoft interviews and more. […]
Bringing i5/OS Resources to the Web
(Erwin Earley) This is the fourth article in a PHP on i5/OS series and it continues our discussion of the API toolkit included with the Zend Core product. In my previous article Use PHP to Bring i5/OS Resources to the Web, I explained that the API toolkit is a collection of APIs for accessing i5/OS
Myth: RESTful Web Services Don’t Need an Interface Definition Language
(Dare Obasanjo) I’ve noticed a meme that seems to have been going around in various blogs of folks who continue to indulge in the long since dead REST vs. SOAP discussion. This meme is that (i) you don’t want or need an interface definition language if you are building a RESTful Web Service and (ii)
Silverlight XAML Primer 5: Working with Radial Gradients
(Dan Wahlin) Silverlight provides linear and radial gradient capabilities that allow different types of shapes to be filled with a range of colors. Linear gradients show colors along a line (refer to my previous article for additional information) while radial gradients show colors within a circle.
Divide and be conquered?
(dbscience) Over the past four articles I’ve demonstrated cases where a denormalized data model is faster than a normalized one, but often not by that much, and a case where a normalized data model was a bit faster than a denormalized one. My general conclusion was with today’s optimizers one shoul
Generate Ajax J2EE Web applications with jpa2web
(Maximo Gurmendez) Learn about, try, and contribute to a new open source tool — jpa2web — which generates J2EE Ajax-based Web applications from JPA-annotated beans. Using the ZK framework, the applications generated by this tool allow your users to add, delete, search, modify, and interconnect insta