I suspect you're also getting recompiles during execution. These will kill performance. You might want to use the KEEPFIXED PLAN hint internally on the queries, but not on the proc...

Sorry, I must have missed the execution plan earlier.

These are going to prevent the code from using indexes:

isnull([@lv_processComparisonDate],[@lv_processCOBdate])<=isnull([MARKET_RISK_DB_US].[publish].[DIM_STRATEGY].[EFCT_END_DT] as [selStrategy].[EFCT_END_DT],'9999-12-31 00:00:00.000'

Also, based on the fact that there are so many...

It only captures events as they occur. Nothing in the past.

Have you looked at the execution plan for the query? It may not be using indexes appropriately, doing scans, etc. If you have a particular query that's killing performance, check...

Do the gambling laws apply if no one is actually, you know, gambling? Although I guess the prizes at the end for the three highest sets of chips could count,...

I guess I meant, is this statement just one of a batch of TSQL statements? You may have received the 0 rows affected from another part of the query.

Is the statement in question a SELECT or an INSERT/UPDATE/DELETE. If the latter, the engine ignores the NOLOCK hint.

The Mode column will show you what kind of lock you're...

I'd suggest running Profiler and either capturing or generating execution plans for the longest running queries. You might also take a look at the dynamic management view dm_db_missing_index_details, *_Group_stats, *_Groups....

Is this part of a bigger batch?

I fiddle around with a bamboo flute, but honestly, I can't carry a tune in a bucket.

On my team, of 14, we have one musician (not counting my screetches). So...

Last question, the columns are dependently or independently overriden? Meaning, if you override one, you may override another at another time, but those overrides are not related? By putting them...

The attempt to insert a row incremented the value. It then rolled back because of the constraint violation, but the increment remained. Identity fields will increment, but they don't guarantee...

We're going through similar circumstances. Look around the site here at some of the discussions on Object Relational Modeling, Hibernate, nHibernate and LINQ. I also posted some of my research...

Notice the topic heading: "Anything that is NOT about SQL"

You should repost this in the 2000 or 2005 General discussions.

It sounds like the database is still a publisher and is...

I'll bet attendence goes down slightly if you charge. I'm good with it. I think it's a fine idea even, but I do think a few less people will show....