<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 General Discussion
»
Advice for array oflarge arrays
19 posts, Page 2 of 2
««
1
2
Advice for array oflarge arrays
Rate Topic
Display Mode
Topic Options
Author
Message
Jeff Moden
Jeff Moden
Posted Tuesday, November 25, 2008 6:59 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923,
Visits: 26,811
It sure does... let's have a race when we're done... CLR vs T-SQL.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #608783
TheSQLGuru
TheSQLGuru
Posted Wednesday, November 26, 2008 9:21 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 3,582,
Visits: 5,130
Jeff Moden (11/25/2008)
It sure does... let's have a race when we're done... CLR vs T-SQL.
Unfortunately I can't be the one to code it.
I have lots of obligations already for the holiday weekend and then will be out of the country for 2 weeks on a rather intense client visit.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #609233
Tom Brown
Tom Brown
Posted Wednesday, November 26, 2008 3:05 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:02 AM
Points: 1,196,
Visits: 1,320
I've got a bit of spare time these days - I'm doing this Fortran replacement thing between the itty bitty niggley things that crop up.
I've not looked at the CLR yet - I have some C code to write the data, can't be too hard to make it C#
maybe this my big opportunity ;)
lets see ... C# probably stores a double in 8 bytes, assume its the same IEEE format as C (and probably the same as SQL float - or is that too much to ask)
so a 1020 array will be 8160 bytes that can be my CLR custom data type
SQL equivalent can just hold a bit bucket varbinary(8160) per data block.
I'm just thinking aloud here
- I need to go read something about the CLR
Post #609475
TheSQLGuru
TheSQLGuru
Posted Wednesday, November 26, 2008 3:46 PM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 3,582,
Visits: 5,130
1) I recommend Professional SQL Server 2005 CLR Programming by WROX
2) SQL 2008 will allow for large CLR types if needed. I didn't review the needs carefully, but I wonder if a structure is best here or a simple array of some flavor.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #609487
Tom Brown
Tom Brown
Posted Wednesday, November 26, 2008 3:59 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:02 AM
Points: 1,196,
Visits: 1,320
The one by Derek Comingore and Douglas Hinson!
By amazingly stupendous coincidence I have that book - I've had it (unopened
) for over a year now. Thanks for the suggestion - never thought of looking on my bookshelf.
Being a bit of a hack and slay kind of programmer (especially at this time of night) - I'm just skimming it looking for something similar to what I want.
Post #609494
Jeff Moden
Jeff Moden
Posted Wednesday, November 26, 2008 9:09 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923,
Visits: 26,811
When you get done with your CLR, lemme know...
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #609545
Tom Brown
Tom Brown
Posted Thursday, November 27, 2008 12:17 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:02 AM
Points: 1,196,
Visits: 1,320
It may take me a while. I'm starting from scratch with the CLR.
Post #609588
Tom Brown
Tom Brown
Posted Friday, December 05, 2008 3:00 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:02 AM
Points: 1,196,
Visits: 1,320
Jeff Moden (11/26/2008)
When you get done with your CLR, lemme know...
Jeff
Tried to PM you - but your PM mailbox is full.
I'm ready with my CLR - in fact I've got T-SQL and CLR versions which both fit the bill - I've written it all up as a word doc - its around 10 pages (mostly code) - I don't want to post this on the forum yet - would you be willing to take a look at the document?
If so PM me with a way to get it to you.
Thanks
Post #614328
Jeff Moden
Jeff Moden
Posted Friday, December 05, 2008 5:46 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923,
Visits: 26,811
Click on my name to the left of this post near my avatar... send me an email.
I'll be happy to look at it through email before you post it, but that's makes a "lost opportunity" for others who might learn something about the "discovery" process you and I are currently going through.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #614420
« Prev Topic
|
Next Topic »
19 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
