Looking for help taking the RBAR from this problem

Question

Post reply

Looking for help taking the RBAR from this problem

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

I am glad you are making progress 😀

I would suggest you keep an eye on this because, from past experience, whenever Jeff goes quiet for a day or two there is a chance he has some outstanding news to impart and he is testing it thoroughly before delivering the blow!

Of course, he may just be busy 😎

Either way, thanks for the feedback so far.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

Hi clubbavich

good luck....I will also be watching this thread for any further posts 🙂

whilst I might not have been able to directly help you..... I have expanded my (very limited) knowledge on execution plans, how SQL optimiser creates different plans ...and just a little on indexed views.

Hopefully there will be some further feedback that I can learn from....I find that quite regularly the threads extend way beyond answering the OP question and can provide detailed insight into various aspects of SQL for those who are prepared to participate...and this is why I really appreciate this forum and its users.

kind regards

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

J Livingston SQL... I can't believe how long it took me to get the joke in your name!

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 4

We can lift ourselves out of ignorance, we can find ourselves as creatures of excellence and intelligence and skill.

🙂

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 5

mister.magoo (9/6/2011)
I am glad you are making progress 😀
I would suggest you keep an eye on this because, from past experience, whenever Jeff goes quiet for a day or two there is a chance he has some outstanding news to impart and he is testing it thoroughly before delivering the blow!
Of course, he may just be busy 😎
Either way, thanks for the feedback so far.

Thank you for the vote of confidence but I don't have 2k8 R2 to actually test on. I have 2k8 but not R2.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)