Or with a fast network where SQL's not going...

Was that via profiler or SSMS's query execution time (bottom right). The latter does include network trip time and everything as it's a display of the time until management studio's...

rw30 (6/28/2009)

---

results shown after enabling SET STATISTICS TIME are almost...

SET STATISTICS TIME ON

and then run your query. There will be fairly detailed time breakdowns in the messages pane.

Mike, I just did some tests myself and, while I do see a small increase in reads, it's not overwhelming.

Use Adventureworks

GO

Create function LineItemTotal(@ProductID int)

returns money

as

begin

declare @Total money

select @Total = sum(LineTotal)...

Grant Fritchey (6/28/2009)

---

I'm...

mike_walsh (6/28/2009)

---

Hey Gail...

Not particularly early. I'd just finished lunch when I wrote that.

I'll do some tests during the week and write up a blog post if I can come to any conclusions.

Actually, I'll blog even if I can't come to a...

Plus it's one plan per execution of the UDF. Also, you cannot trust statistics IO when you have a udf that does any form of data access.

So how are you doing the save to...

Not offhand. Does google turn up any suggestions?

Why do you need management studio on the server?

Call Microsoft's Customer support. You've got stack dumps there, I don't have the tools to interrogate those and I don't have SQL source code. Customer support has both.

Phil Jackson (6/27/2009)

---

1 data file per cpu is definately a great idea, the reason for this is for parallel writes i.e. 4 cores, 4 threads, all write at the same...

Dropping an index that's used for enforcing of a pk constraint isn't allowed. To drop the index that's enforcing a pk, the pk itself must be dropped/

CREATE TABLE Test1 (

...