Be aware that LEN does not count trailing spaces.

SELECT LEN('abc') -- 3

SELECT LEN('abc ...

Yes. I was more referring to the other NC indexes.

As I mentioned in another thread, that cluster is exceedingly wide. The recommendations for clustered indexes is that they are as...

What's the name of that file?

It's possible that it's the windows swap file, which means SQL's using more memory than the machine has available and windows is swapping it to...

Without seeing the table structure, or the index definitions, it's hard to say.

You could probably widen a couple of the indexes and it would reduce the lookups. Without knowing the...

karthikeyan (4/23/2008)

Carl Federl

As "where (@Nm) is null" will always be false, zero rows will meet the

restriction....

He wants to specify the column name in a variable.

Because the variable @Nm is not null. It is equal to 'Age'

If you want to have a variable column specified in the where clause, you'll have to use dynamic SQL,...

That's not what spaceused is saying.

Spaceused lists your data size (the clustered index) as 12 GB. The page count confirms that.

What spaceused lists as index size is the total space...

You're referencing the table FDIT_SAP_AUC_IMPORT in the set and in the where, but it's not in the from.

Is this perhaps what you want?

update FDIT_SAP_IMPORT

set AUC=FDIT_SAP_AUC_IMPORT.auc

from FDIT_SAP_AUC_IMPORT

where FDIT_SAP_AUC_IMPORT.WBSnumber=FDIT_SAP_IMPORT.wbsnumber;

Can you post the entire query please, the table structure and all the indexes on it? Also, please save the execution plan as a .sqlplan file (right-click the exec plan,...

It might be. How many other indexes do you have on the table?

Run this and see what it regarding page count for the clustered index (index_id 1) and the other...

Maybe.

Can you post the entire update statement please?

Try connecting from full management studio, rather than management studio express.

You can install the workstation componenents alone on your client PC from the same DVD that you installed the server.

btw,...

Not that I know of. In SQL 2000, encryption means that the object cannot be scripted of modified without either having the original code, or decrypting the proc.

Especially in SQL...

It still works in SQL 2000 and later. What error are you getting?

This works fine in SQL 2005

CREATE PROCEDURE Test

WITH ENCRYPTION

AS

SELECT 1