You are right.  It is lazy on our part.  We develop processing classes on the desktop because we can edit and continue (not available on the device).  We can port the...

Sergiy, we don't do joins on domain tables in the device code.  The only place that we do joins to them is for reports and those are done on desktop.

Because...

I've been using SQL Server with PHP for many years.  Look at ADODB by John Lim http://phplens.com/phpeverywhere

I've used MySQL on projects too.  No real stored procedures yet.  All the tools that...

Terry,

Much the same philosophy came from William Piper, who founded Piper aircraft.  He thought that if flight students trained in Piper plance that they were more likely to buy...

Thank you.  This is exactly what the testing showed.

I raised such a stink about it that they finally agreed to go back and put identity columns on all tables.  Well almost all.  There are a couple that don't...

Good points, William.  Then go look at MySQL.  They give away most of their products and only charge for support.  It's good stuff and comes close to SQL server.

USE [Production]

GO

/****** Object:  Table [dbo].[State] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[State](

 [Code] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 [Description] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

 [SourceSystemId] [bigint] NULL,

 [LastUpdateTime] [datetime] NULL,

 [UpdateStatus] [nvarchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

GO

SELECT [Description] FROM...

Thanks, Steve. My picture is on the way via e-mail.

To Gift Peddie:  Shallow, no.  Not all of us.  It's just that for some guys "deep" has a shallow meaning.  Did...

In one application we have a bunch of small domain tables.  Things like state codes and names, transaction type, payment types, user types, and on and on.  None with more...

You do understand that the Mac run OS-X under the covers.  I had a co-worker who's a Linux guru.  He was helping his neighbor with a Mac.  He jumped out...

Agreed, an alpha field for clustered seems strange.  But then so does 341 for a field length. Sometimes we are not in toal control of the design.  I just hope...

Check the database design.  I had one coworker who put a clustered index on a table and included the last update time field.  Every time a row got updated it...

Ah ha.  Right you are.  So we can only go on the available evidence.  Your charts (even with broken links ) and the...

You said, "The plans do not give any clue to their performance difference."  But there ARE indications.  The thickness of the arrows are a real indicator.  The thicker the arrow,...