No you can't call sp because by DESIGN the function CAN'T change the data.

What the heck are you trying to do that requires you to use functions to do????????

That's a choice made by the dev team at MS.

Maybe there's something in the sql standards as well.

Bottom line is.

That's how it is. Then end, move on,...

There's no secret here to perf tuning.

Find the slowest thing <in a group> and make it run faster. As I said earlier in profiler you can include the statement...

Who's the moron who did that... let me complain to Steve about him on your behalf! 😀

NJ-DBA (9/26/2011)

---

NJ-DBA (9/26/2011)

---

If, for example there are a large batch of statements like

select * from table1 where cola = @variable

delete from table1 where colb =@variable

It seems that DTA can...

This seems very oversimplified, hence we can't help ;-).

There's very little to do here to solve the problem. Add the index on that field.

Assuming there are enough...

SanDroid (9/26/2011)

---

Ninja's_RGR'us (9/26/2011)

---

SanDroid (9/26/2011)

---

I remeber that one well, but...

Do you ACTUALLY try what I write?

getdate returns...

I preffer to use won't (in my head) instead of might.

That way it lives no place for ignoring the need of the order by in the final step.

And...

SanDroid (9/26/2011)

---

I remeber that one well, but in that...

Actually it's 201!

http://www.sqlservercentral.com/Forums/Topic1144668-1198-1.aspx

Getting there... mine had over 110 iirc.

Is that your prefference for ssrs server over replication?? I hate having to disconnect the users every x minutes to restore...

Actually I've seen dynamic search queries takes as much as 485 ms AVG to compile. Then only 30 ms to run :-D.

I never had the chance to test against...

Trace to see the real total cost.

You can see it by statement & batches. And get the actual execution plan as well.