Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Advice for array oflarge arrays Expand / Collapse
Author
Message
Posted Tuesday, November 25, 2008 6:59 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
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 "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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #608783
Posted Wednesday, November 26, 2008 9:21 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:16 PM
Points: 4,471, Visits: 6,401
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
Posted Wednesday, November 26, 2008 3:05 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:50 AM
Points: 1,234, Visits: 1,435
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
Posted Wednesday, November 26, 2008 3:46 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 7:16 PM
Points: 4,471, Visits: 6,401
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
Posted Wednesday, November 26, 2008 3:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:50 AM
Points: 1,234, Visits: 1,435

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
Posted Wednesday, November 26, 2008 9:09 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
When you get done with your CLR, lemme know...

--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #609545
Posted Thursday, November 27, 2008 12:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:50 AM
Points: 1,234, Visits: 1,435

It may take me a while. I'm starting from scratch with the CLR.
Post #609588
Posted Friday, December 5, 2008 3:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:50 AM
Points: 1,234, Visits: 1,435
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
Posted Friday, December 5, 2008 5:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
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 "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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #614420
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse