It is moving it on the same server.

I'm asking more for curiosity sake than anything. 

As standard practice I use the articles you wrote on moving databases to put the...

That 8000 characters includes white space and some white space characters can break your SQL.

The only problems I have had are when unicode text (which takes twice as much space) gets...

The signature is allegedly the marriage proposal that the actor, Robert Mitchum, made to an actress whose name escapes me.  I think she accepted.

Yes,

I have a stored procedure that has a @choice argument.  Depending on the value of that argument I execute various stored procedures.

The other thing that is possible is to create...

A common mistake is to confuse connections with users.

One connection is automatically taken up with  by SQL Server itself.

If you have EM and QA open then you've just used another...

I think the point at which the "throttle" become noticeable depends on what you are doing with the database.

I've had over 25 users on bog standard Access 2.0 but all...

If you are going to use a case statement in your WHERE clause, I would put one in your SELECT as well to warn you that field2 is zero.

I did consider writing some matching functions for SQL Server having written a number of deduplication programs.

In the end I shyed away from it because it involves heavy string manipulation...

 I know you don't have to specify the owner, but MS made a big song and dance about it being best practice.

I am also a fan of Metaphone.  The guy who wrote it (Lawrence Phillips) went on to work for Verity, the search engine people so that should tell you something.

Unfortunately...

I have to admit outsourcing scares me witless.

In the States it may have been the case of someone working for US$7/hour instead of US$10/hour but outsourcing to India means competing...

Try full text indexing

A primary key defaults to a clustered index, but you can choose explicitly not to cluster it.

I'm pretty sure that a a primary key is needed for certain types of replication.

I'm...

How many Mb does 9 Million records represent?

If you run the following query

SELECT SUM(Length)

FROM SysColumns

WHERE ID=Object_Id('dbo.<<your table name>>')

You will get a very crude idea of your record length.

Multiply this by...

How big is the phsical TEMPDB log file?

Is it set to autogrow?