Commenting on paul.....

I don't know what kind of server you have but on my laptop.....

for a 10 year period I came to 120 for yours and 450 for mine...

so approx...

Paul,

A couple of commets on your assumptions.....

We don't know if the poster of this thread uses 7. If he uses 2000, I think my solution is the best yet, because...

Paul,

be creative...

If a memtable doesn't work.....

Use a temp table.....

Solution is still the best......

Thanks for the tip Antares.

But beware, the guy who wrote the article is probably the guy who programmed them in SQL..... (That's why he is so happy about it)

Me...

Does this mean that for some more complicated queries a SPROC is faster and for the very simple basic selact an UDF is faster or is a SProc ALWAYS faster...

You see what i mean crappy.....

Maybe you don't have a perf problem right now but if you get one later and you use functions, you cannot tell where the performance...

Crappy,

I am really puzzled by the findings. Because in real life systems I have found many performance problems in UDF's....

It is my job to solve those problems....

Many of those problems...

Crappy,

I have seen systems with functions.

Rewriting the UDF to SP's have solved a lot of performance problems....

I think your test is unrealistic.

I liked andy's article but there is nothing about stored procedures.....

I know now how to write a query and how to format it but what aboud declaring variables etc....

( really...

I Like it !!!!

Mayuresh....

Have you looked in the profiler tro see if there are long running queries....

You can look everywhere but the basic information of where to look is provided by the profiler.

Look...

Well I am glad that we both agree on that.

And I do agree with you on the memory usage.

Nowadays nobody thinks of the mem usage details. But I tried...

Simon

Muyaresh states the following :

but for crystal reports i donot use any sort of join.i have created one table for that.everytime i fire a report. i dump data into...

Mayuresh...

I am wondering why you mention the 1 GB... 1GB is NOTHING, even my home computer has more..... So 1 GB is really NOTHING.

Furthermore I am really curious at what...

Well..

First start the Profiler and profile the Long running Queries....

Or more time consuming but you will see more.

Start the profiler with the 'SQLProfilerStandard' profile. This one also records duration....

Then have...