ashu.sajwan (2/17/2014)

---

...

col1 varchar(Max) NULL,

...

CREATE UNIQUE CLUSTERED INDEX cuq

ON dbo.ExampleUnique (col1);

It shows error: Column 'col1' in table 'dbo.ExampleUnique' is of a type that is...

dog

Yes, you are on the wrong forum. ASE is a Sybase product. I imagine there is a forum somewhere for ASE T-SQL.

I think your problem is that the...

It's easier with varchar, nvarchar, and varbinary since it's generally not too difficult to convert the primary key to one of those types; other column types could be an...

I'm inclined to go with an "It Depends" answer. In the past I've worked a lot with binary files outside the database, in filestore, and it's been fine; sound...

fsuoj (2/17/2014)

---

I am not trying to be difficult but no one in this thread has answered my question. How does SQL know to look for anything trailing the AAA...

The reason it isn't documented as happening that that happens is that it doesn't happen.

Several people have explained what actually does happen, which...

Interesting question.

I could have this wrong :ermm:, but:

The statement in the article referenced may apply only to the initial snapshot generation on the publisher (ie to generation of the schema...

mike 57299 (2/16/2014)

---

According to the article, the Quirky Update is still significantly faster than the 'Over' option. Has there been an update or change on this?

Can others...

That's...

Evaded

Goodbye

Only the optimistic cynics! 😀 Realist cynics will point out that a $ is not...

???? ? ??? ?

Can anyone take a look at thisamd suggest something better than what I have?

I've made an attempt to help, but I'm worried that my only idea is to use a...