You have given us the table definition and sample data, and that is great.

However, there is not really any good description of the business rules and what is the expected...

Run this in tempdb:

SELECT o.name AS objname, c.name as colname

INTO tempo

FROM sys.objects o

JOIN sys.columns c ON o.object_id = c.object_id

go

CREATE STATISTICS stringstat ON tempo(colname) WITH...

Yes, you could use these values, but you would need to sample and aggregate them. There may be a session with high CPU values, but which has been idle for...

Could you post the example you are talking about?

So when you say that the performance depends on the order of the conditions, you are really talking about queries in two different databases.

Since the optimizer determines the query plan...

SQLSteve (8/7/2013)Its getting stuck at the first step. When I run the steps outside of a job it all works. Step1 is failing in the job saying @subdir is not...

When you use a CTE, SQL Server treats it like a macro, and replaces all references to the CTE with the query text, and the optimizer works with the expanded...

TheSQLGuru (8/7/2013)

Although depending on...

Note that it is a little tricky. See this section on my web site:

http://www.sommarskog.se/grantperm.html#context_info. Note that you only need to read down to the next header.

Yes, but SQL Server may internally implement that UPDATE as INSERT+DELETE.

Review this search result from Google for samples on how to write a CLR procedure.

You are not going to call the procedure from your trigger, I hope?

So...

I would assume that this happens when an UPDATE is not implemented as an in-place update, but as INSERT + DELETE.

Sorry, but you will have to colour me as completely clueless. You are copying data from one database table to another. Where does the spreadsheet come into the picture?

I am...

1) Don't name your stored procedures sp_something. The sp_ prefix is reserved for system procedures.

2) As far as I can see there is a 'k' in both "Alexandra Park" and...