Because of the N-prefix the value is cast to NVarChar. The NVarChar(MAX) can contain a maximum of 4000.

BOL:

nvarchar [ ( n | max ) ]

Variable-length Unicode character data. n...

Hi,

You can find this information about the N-prefix in the BOL:

Unicode string constants that appear in code executed on the server, such as in stored procedures and triggers, must be...

Hi,

You can setup a trace to log the locking. Run this trace during the execution of the SP.

You might want to ensure you are the only user, to prevent too...

The discussion becomes very interesting. I didn't know that NOLOCK can cause so much issues.

But when I read the BOL I read the following "NOLOCK: Does not issue any locks....

Thanks Grant,

Your post made it all clear now. The query is a SELECT so the NOLOCK should apply, but I can now continue analyzing the trace why and on what...

In the design of the foreign key you can specify a delete rule. Like you said the CASCADE option is what you need. The following is from BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/08812343-e9a6-4a0f-91fd-80d95ab4b71f.htm

INSERT and UPDATE...

I have only taken a short look at it. I see in the WHERE clause you often use:

value IN (SELECT xxx FROM yyy WHERE zzz) OR value NOT IN...

You can install both version on the same box. But you'll have to look at your performance if it is workable.

Use Windows Performance to set counters on diskspace/access and memory usage. Also set counters to monitor SQL buffer cache and re-compilations. These counters can show you the direction to look...

Look at the execution plan....

I think you mean Archive Tables.

These are tables where you can transfer data to that is not immidiately required.

Say you have a transaction table where you insert several thousands of...

Ahmad Osama (4/17/2008)

It works:)

What if I have varchar column...

You can also use the Bitwise NOT function (~) by using a query like:

UPDATE inventory SET iLease = ~ iLease

Regards,

Hans

Besides the different tools available, you can also set alerts on various things you want to monitor.

You can get an alert when a SQL-job fails, when space drops below a...

It looks like you haven't defined an Operator yet. Look in SSMS under 'SQL Server Agent' and 'Operators'. You probably have to use a group mail to notify multiple persons...