OK, I'll see if I can get any traction on the issue of Websphere and/or Java defaulting to varchar(8000). I don't know how it is configured on that end so...

Thanks Kevin and Gail. Very good observations. I'll be bringing both to the attention of the developers. It is an in house application so it is not surprising that...

On its own, it is checking the table to see if there is a persisted computed column that has a NCI that matches the WHERE criteria. That's pretty great....

I get it that they look the same but I did not know that SQL Server was smart enough to use an NCI on a computed column that is not...

Lynn's solution got us through it. I don't understand why it worked but it did.

Creating a persisted computed column with '_' + PK and then creating a NCI on that...

Absolutely the query should be rewritten but it is TG week and the person is out of the office all week.

It would be useful for me to learn...

Ok, I'll explain.

We have a product that the company has been using since the late 1980s. They are switching to another product to replace it. The new product...

This is very interesting (to me).

I deleted the other NCI so that I only have the CI and the also NCI that is based on the persisted computed...

I created a persisted computed column to matchthe where line.

alter table table10 add merged as '_' + cast(pk as varchar) persisted

create index test2 on table10 (merged asc)

The query plan does...

They are using it to create an export of the column to a text file. The _ + primary key is how they want to label the file name...

Thanks for making this script. It looks really nice.

V3 that is posted no longer includes the source script url in the comments section of the script. (

Thanks, I'm not sure that it is possible to capture the informational line of the throw to a variable so it can be logged to a table.

yes and no... I worked with Microsoft support in a screen share and we found that there were some missing registry keys. Thinking back, I think that was due to...

Definitely use Windows Server 2012 R2 if possible. The multi-subnet clustering is much improved due to dynamic witness.

Thanks for your response Perry. I'm stuck at SP1 on this one.

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)

Oct 19 2012 13:38:57

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit)...