Nothing to add since you asked yesterday

http://www.sqlservercentral.com/Forums/Topic798948-360-1.aspx

This is the best illustration i've found on the perils of nolock

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

It may be possible to bluff your way through an interview, but you will be thrown out the door when a server crashes and burns and its pretty obvious...

Sql doesent work like that , it wont increment the value .

Iternally its not doing a lot different from operating on the results of a select.

You need to do something...

Something like this ?

If not suitable please post DDL and sample data in the form of inserts

with cteTiming(EmployeeId,Date,Start,End)

as

(

select EmployeeId,

Date,

...

Try these articles....

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

You need to use partition by

row_number() over (partition by column1 order by .....)

Can you narrow it down further ?

Im guessing that its code within the udf's, that is taking the time.

Try rewriting them using proper set based logic.

use something like

row_number() over (order by column1 ) /50

Sigh....

http://www.sqlservercentral.com/Forums/Topic798381-145-1.aspx

Please see this article on how to post performance problems.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

It will take the guess work out of it...

This is ,as you say, a big concept, and one that is impossible to summarise effectively.

IMO, you are looking at the problem the wrong way.

It's not a question of how...

Untested (again) ....

select customer,sum(total),max(locked)

from (

SELECT customer,sum(doctotal) as total ,max(case when Locked='true' then 1 else 0 end) as locked FROM Invoices

GROUP BY customer

union all

SELECT customer,sum(doctotal),max(case when Locked='true' then 1 else 0...

Seems fine now, just a temporary thing i guess.

TBH , its hardly worth the click though 🙂 simple Q and A

If i understand you correct , this should do...

select customer,sum(total)

from (

SELECT customer,sum(doctotal) as total FROM Invoices

GROUP BY customer

union all

SELECT customer,sum(doctotal) FROM Credits

GROUP BY customer

union all

SELECT customer,sum(doctotal) FROM InPayments

GROUP BY customer

union...