Viewing 15 posts - 781 through 795 (of 805 total)
You can normally do away with cursors with temp tables. Populate a temp table (Either variable or normal) and loop through it. I have used this many times with large...
March 6, 2003 at 10:23 pm
March 6, 2003 at 6:13 am
ERROR AT KEYBOARD, I like that.
In all honesty, I do belive that it's a user error. PEBCAK (Problem exists Between Chair And Keyboard) error.
The problem is they want to know...
February 23, 2003 at 10:43 pm
The easiest and fastest I would think (not knowing if the tables are related) is to have an IF statement around the two selects.
If @CurrentID > -1 OR IS NOT...
February 20, 2003 at 1:03 pm
Is there any relation between the to tables?
February 20, 2003 at 12:29 pm
Greetings,
There should be 3 msxml dll's in your sys32 dir. If you have msxml3.dll, you have version 3. Last SP I downloaded from MS (About 2/3 months ago) set the...
February 15, 2003 at 5:54 am
ya, this all makes sense now. This is why people say that UDFs are slow. I am sure in their tests, they use it as part of a select.
In all...
February 12, 2003 at 1:18 am
Well0549,
If you call a function as part of a select, does the function not get called once for each record? ie: You called the function 20000 times?
This would...
February 11, 2003 at 10:35 pm
ahhhhhh, Found the Problem. (This only affected the last post!)
The UDF had an unfare advantage. The proc was doing a between in the last query where the UDF was doing...
February 10, 2003 at 1:50 pm
O well, there's that theroy down the drain.....
Still faster. Not as fast as a simple query though but still twice as fast.
All the tables are large(ish)
When running the proc and...
February 10, 2003 at 1:38 pm
I was having a look at another thread Use of functions Do or Don't http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=9683.
Well0549, you said there that you found UDFs slow. Antares, you I thing, also added some...
February 10, 2003 at 12:46 pm
Sorry, to answer your second question, No, I have not tried views yet. Will get to that later on today.
Crispin
February 10, 2003 at 5:30 am
hmmm, I see what you mean. Yes, that could be a problem.
But, I think I could life with it considering the increase (Apparent) that I am getting.
What I am busy...
February 10, 2003 at 5:29 am
Viewing 15 posts - 781 through 795 (of 805 total)