(Mads Kristensen) I was playing around with HTTP request headers and for some reason started thinking about how limited information they provide about the requesting browser.
Other News
How Many Data Files Should I Create for a User Database?
(Linchi Shea) Whenever this question comes up, my typical response is to pass along the following Microsoft recommendations: –The number of data files within a single filegroup should equal to the number of CPU cores. See the "Physical Database Storage Design" whitepaper. –Lining up the num
SqlCredit – Developing a Complete SQL Server OLTP Database Project
(Rob Garrison) The purpose of the SqlCredit series is to demonstrate the database design and development portion of a development project. We will build a complete, functioning, tested credit card database to illustrate the complete software development lifecycle. Microsoft provides us with Adventur
Working with nested subqueries in SQL Server
(Arthur Fuller) Many SQL Server programmers are confused about the use of subqueries, especially nested subqueries (i.e., a subquery that contains a subquery). Let’s start with the basics.
Create data structures with JavaScript arrays
(Tony Patton) While JavaScript has many similarities to more robust languages like Java and C, it does have many features that are less than intuitive. JavaScript arrays are one such design element that provides some obscure features that developers often overlook. This article examines some of thes
An idea how to speed up nested-loops join a little
(Sergey Petrunia) Working on subquery optimizations, got an idea how to speed up join execution a little. Read on.
Invalid GROUP BY queries
(Rudy Limeback) I have a single (Oracle 9i) table which captures events with the following columns: Source (VARCHAR) Event (VARCHAR) Time_Of_Event (timestamp) a number of other detail columns, call them Detail1, Detail2, etc. (R)
Using collections in WebSphere Service Registry and Repository to resolve versioned imports, Part 1: Creating and managing versioned documents
(Bernard Z. Kufluk and Ian Heritage) IBM WebSphere Service Registry and Repository V6 (hereafter referred to as Service Registry and Repository) is an industrial-strength tool that helps you achieve more business value from your service-oriented architecture (SOA) by enabling better management and g
Submitting to a Database (via Web Services) in InfoPath Forms Services
(Forrest Dillaway) If you’ve ever designed and deployed a form that will be frequently used or require significant data analysis, you have probably looked into maintaining data in a SQL database. With InfoPath 2003 and the InfoPath 2007 rich client, you get what you expect. You create a main datab
Full-text searches in natural language
(Il Corra) Answering yesterday to some newsgroup question about MySQL I have answered about the problem of the full-text searches in natural language.