What would be the expected behavior had the tables been defined with varchar(9) and varchar(10), instead of char(9) and char(10)?

I've always used the other way around. When 0, then fail; when >0, then success. Is the SQL Server documentation incorrect?

Thanks. My confusion was due to the fact that when I first create the table and I script it, it returned "data_compression = page" only. But once I added...

Let me be more specific with an example.

create table A

(

IndexID int identity(1,1),

Col1 int,

Col2 varchar(30),

constraint PK_A primary key clustered...

That's what I thought. Thanks, Gail.

I also want to mention that this was just an example and the business uniqueness requires combining 6 columns.

The identity column is needed because I may get an odd case...

Thanks for the answer.

What would be the benefit of creating a non-clustered PK on IndexID and a clustered index on ID1, ID2 and ID3 over the other two options? In...

I've cleaned up before and I sure will cleanup again, no doubt. Maybe I'm lucky and it only happened a handful of times over the last 15 years or so....

I agree they are not academic, but it depends greatly on the applications and database designs. I am so used to not being able to use FKs that I don't...

There are cases where FKs are hard to implement and there is a need to do it in the application, especially when you are doing in-table audit trail. Here's a...

I don't know what was going on in my head. Thanks very much.

You are correct. The query won't work without an aggregate. However, going back to my original question on the usage of sub-queries. So far I have the...

Thanks, everyone. In the end I'm using the EAV for metadata only. I created a stored procedure that runs every time a new attribute is created (trigger) to generate...

Yes, my table is quite large and it does have primary keys, and I do generate the code automatically. In any case, here's a version that I ended...

Grant, would it be possible to post a link to the event name or the document you saw, in case it is public domain? Thanks