And it appears that the default size for varchar and char is 1

It does not only appear so, it is so

VARCHAR is equivalent...

Make sure you read closely the explanations givven in BOL under CREATE INDEX -> Creating an index. Here's the management summary:

"If a clustered index is created on a table with...

...and make sure you're in the correct database where SQL Server can find the tables you've referenced.

Surely not, but that one changed the whole world for a long time and brought the most pain to mankind so far...

I'll stop now.

You've got me again more involved...

What do you expect on a Friday afternoon?

Maybe, maybe not. Tendencies are still here. Just like in almost any other country, too. But that's politically incorrect to say.

Oops, sorry. No, there is no setting I know of. Default is that constraints are ignored unless you explicitely state otherwise.

You're welcome!

No, not really. Considering all the sh*t Germans did some 60 years ago, it really isn't.

Sorry,

Looking at my crystal I see:

1) Table scan or Clustered Index Scan

2) Scan of the narrowest index SQL Server can find. If no index present, I think table scan

3) Index...

FWIW, see if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

Although I'm still not sure what you mean by "channel" and "data structure", I suspect a look at SQL Server's Books Online for INSERT INTO SELECT will help.

BOL is a very good and handy reference.

Currently, you have DECIMAL(18,0) which is at 9 bytes per row. Even BIGINT is only at...

Another speculation.

If you mean the table structure and related information, have a look at sp_help.