Viewing 15 posts - 49,996 through 50,010 (of 59,078 total)
Wilfred van Dijk (6/16/2008)
Why write some unreadable code in order to avoid cursors?
Why do you think it must be unreadable?
June 16, 2008 at 7:00 am
Then, don't buy a book... start working problems posed on this forum. 😉
June 16, 2008 at 6:22 am
Oh no... Correlated sub-queries and their equivelant of Cross Apply are nothing more than a form of hidden RBAR which is usually as slow as a cursor and sometimes slower...
June 16, 2008 at 6:15 am
"If we let our employer know of the trade-off between delivery schedule and future-proofing/performance tweaking, they can make an informed decision."
I've found that that usually takes more time than just...
June 16, 2008 at 6:11 am
Please see the following to get the best performance out of a concatenation function...
June 16, 2008 at 5:56 am
michaela (6/15/2008)
What I would do:...
June 15, 2008 at 8:08 pm
Sorry folks... I've repaired the link that BitBucket was talking about and I've also included it here...
June 15, 2008 at 7:28 pm
Ummm.... SysProcesses has a DBID column...
June 15, 2008 at 7:21 pm
kinnon_2000 (6/15/2008)
I dont know of a sql server query that could concatinate multiple fields from a tabe, as a join, into a single field. Can that be done?
Absolutely... see...
June 15, 2008 at 5:33 pm
Virtual Machine is software that looks like hardware. Do you think software will ever be as performant as hardware? 😉
June 15, 2008 at 5:15 pm
Sure... let's shed some light on this... this sounds like you're processing one row at a time... That's RBAR and that's a mistake. 😉
June 15, 2008 at 5:10 pm
In fact... it doesn't even have to refer to a table to be RBAR... and split function based on a While loop is a form of RBAR and performance can...
June 15, 2008 at 5:07 pm
Bottom line is, if the function, inline or not, refers to a table, it's a form of RBAR that may have a significant impact on performance whether the execution plan...
June 15, 2008 at 5:04 pm
rbarryyoung (6/15/2008)
June 15, 2008 at 5:02 pm
Viewing 15 posts - 49,996 through 50,010 (of 59,078 total)