I don't mind things being tidy.  Neat is often a good thing.  However this should not, IMNSHO, trump considerations of performance.

Having the log on a different data channel from the...

Watch also the configuration of the SQL server.  It might be setup for only named pipes and not TCP/IP.

We do access to SQL server via only TCP/IP all the time. ...

I like just have the OS and very little else on C:.

If you are splitting things then put you data files and log files on separate drives if possible.  Not...

An open discussion can bring out many good things.  Herb is OK though.  It is right to question everything.  Even the forum process.  Questions are the things that spur research.

We...

I participate in forums as a way to demostrate that I am keeping up on industry standards and best practices.  I am very careful not to post trade secrets or...

Oh! So 28 to 465 million per month.

You might have to solve this in code.  The execution plan must be a horror show.  UNION ALL is not going to be kind...

On each of the 31 under tables do you have an index on route and another one on clientservice_id?  If not then write a script to create...

Herb one reason might be employement contracts.  One might be allowed to participate in a forum but if that same person publishes an article the employer might actually own it...

I was going to ask you where the heck is the library name?  Do you have some SELECT statements that work?

I never did get the linked server thing to work...

Well noted.  We "rolled our own".  We have an exclusive server piece that lets us run SQL queries from the handheld.  I then use that data to do my inserts...

In there he says, "PostgreSQL, on the other hand, requires you to do a little tuning here

and there and know a little bit about databases."  Ther is one reason that...

"Are you going to trust your corporate payroll data to the 'clone'?" is a good question.

If the clone has support options (a la MySQL) then why not.  With something like...

I also agree with opensouce != unsupported.  Sure I can get the source for MySQL and do my own builds.  Why bother.  They give me the Windows builds and actually...

They just downgraded Pluto not killed it.  Pluto is one thing but it's a good thing that they letft Goofy alone.  "Gorsh!"

One of my customers has a big Dell tower (don't remember the model) that they use as one of the SQL servers in their plant.  One day one of the...