I have a CLR function thet returns IEnumberable (a table) ..

FAQ

Profile

I have a CLR function thet returns IEnumberable (a table) ..

Database Forums (Home) -> Clustering

Next: resizing an image with the gd library

Author

Message

External

Since: Oct 23, 2007
Posts: 27

(Msg. 1) Posted: Mon Nov 19, 2007 7:36 pm
Post subject: I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am returning 10,000 integers from this function. Is there any way that I can preallocate the resulting table or give SQL server hint as to how many rows my function
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

I have a CLR function thet returns IEnumberable (a table) and it has a
FillRow function. I am returning 10,000 integers from this function. Is
there any way that I can preallocate the resulting table or give SQL server
hint as to how many rows my function will return? It makes me cringe to
think that every time FillRow is called that sql may be doing some memory
allocation to make the resulting table bigger.

>> Stay informed about: I have a CLR function thet returns IEnumberable (a table) ..

Display posts from previous:

Related Topics:

How to genericaly search the entire db for any text string.. - How to genericaly search the entire db for any text string in any stored procedure, function, table definition, agent job, etc. Any one command or anyone have a stored proc that does this wide search?

mySqlBytes.buffer is getting converted to BigEndian even t.. - mySqlBytes.buffer is getting converted to BigEndian even though both SQL server 2005 and the CLR function are on the same machine which shows BitConverter.IsLittleEndian == true in tsql: select * from dbo.MY_CLR_FUNCTION(cast(1024 as binary(4))) ..

how to find out if a TSQL table is being updated? - how to find out if a TSQL table is being updated? for example if someone does an update to a table that takes a long time, is there anyway for me to check the status of that update process?

Enterprise Manger against remote cluster - Newbe question; how to connect to a remote cluster over VPN (Cisco) with Enterprise Manager (EM)? Client connectivity installed locally and failover cluster running remote with Cisco software VPN-client between. I successfully registered the server....

SQL Reporting Service on Cluster server - Hi, If I install SQL RS Enterprise on SQL Cluster , do I have to create IIS Cluster Resource for the "Reports" and "Report Server " web virtual directory ? Norman

	Database Forums (Home) -> Clustering	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum