Here's a list of recommended reading for MCM status (although this is 2008)

https://dynamicevents.emeetingsonline.com/emeetings/dynamicevents/290/MCM_SQL2008_Pre-reading_v3.pdf

Read it , understand it , practise it , pass the exam and its as simple as that

Not quite 2010 yet , but happy new year to you all...

Also in your view ei_tc_doc_wbs_current.

The subquery 'b' , doesnt seem to have any practical use.

The values arent used ?

-- EDIT Scrub that....

It used to get the row with the...

The estimated row counts differ quite badly from the actual row counts, generally this is a sign of out of date statistics.

There is also a big logical difference in the...

Try

Begin Transaction

exec MyCallingProcName @Param ="Whatever"

Select 'TransCount',@@TranCount

Commit

Does that work or error ?

Have you tried wrapping the insert exec itself in a transaction ?

Jeff Moden (12/30/2009)

---

Here we have someone who has no clue as to how to use one the basic 4 elements of the SQL language and they're going to update a...

As...

Statistics are used by the optimizer to get the 'fastest' query plan.

Try this link

http://www.developer.com/db/article.php/3622881/Basics-of-Statistics-in-SQL-Server-2005

Im guessing here...

Update yourtable set c3 = c3+' dont use'

Is that what you mean ?

What do you mean by registry ?

I really dont understand your needs.

First off check your statistics are up to date.

Also can you post the execution plans?

Something like this ?

with cteBinary

as

(

Select Id,ParentId,ROW_NUMBER() over ( Partition by ParentId order by Id) as SideInt

from #MyBinary

)

select Id,ParentId,case when SideInt = 1 then 'L'...

Yup, the execution plan is the place to look.

Remove that function immediately.

Once you get a nicely loaded database performance will be severely impared.

SQL Server has no option but to evaluate the function for each row REGARDLESS of any...