(Richard Foote) I’ve already written a few posts regarding concatenated indexes and things to consider (and not consider) when deciding the column order of a concatenated (composite) index.
Other News
Rename the database? WHY?
(Hans Forbrich) I’ve seen repeated questions around renaming the XE database. Many of the reasons are not legitimate – you really can only use one XE at a time on a specific system.
Writing CLS-Compliant Structures in Visual Basic 2008
(Alessandro Del Sole) Many developers already know what the Common Language Specifications (CLS) are: a set of rules that every developer should adhere to make sure their managed assemblies can work even when referenced by applications written with programming languages different from the one used b
Faceted navigation for document discovery
(Alan Marwick) While there are several different ways for a user to specify metadata conditions, this article discusses one that has special advantages: faceted navigation. Follow the faceted navigation system described in this article, a technology demonstrator based on IBM Omnifind Discovery Editi
Evaluating IO subsystem performance for MySQL Needs
(Peter Zaitsev) I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some simple steps you can take to get a good feeling about it, it is not perfect but usually can tell you quite a lot of what you should expect from the sys
Set Functions: The AddCalculatedMembers() Function
(William Pearson) In this lesson, we will introduce AddCalculatedMembers(), a basic, but highly useful, set function in the MDX toolset. The general purpose of AddCalculatedMembers() is to retrieve the base members of a specified set, together with all sibling calculated members.
You cannot remove the GUEST account after you install the SQL Server 2005 client tools on a computer that has the SQL Server 2000 client tools installed
You have a computer that has the Microsoft SQL Server 2000 client tools installed. You install the Microsoft SQL Server 2005 client tools on the computer.
2008: Rebuilding a Heap
(Louis Davidson) In 2005, rebuilding a table that was a heap (no clustered index) wasn’t easy. You could copy it to a different table, or you could add a clustered index and then drop it.
IIUG View: Informix Runs Ahead
(Stuart Litel) Welcome to 2008, which looks to be another great year for Informix. I’ve often said that I never saw a customer leave Informix for technical reasons, and I still stand by that claim.
Dynamically build connection objects for Microsoft Access databases in SQL Server Integration Services
(Hal Hayes) As a portion of our daily data upload process, we receive data in the form of Microsoft Access files (*.mdb) which needs to get uploaded to a SQL Server 2005 database. We want to build a SQL Server 2005 Integration Services package that loads all our Microsoft Access files and uploads d