<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://203.81.62.81/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>DarenHan's Blog - All Comments</title><link>http://203.81.62.81/blogs/darenhan/default.aspx</link><description>I am a Dot net asp.net developer working with VS 2005 and SQL 2005 now.

</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 (Build: 30912.2823)</generator><item><title>Pages tagged "cumulative"</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/12/20/zero-day-vulnerability-for-internet-explorer.aspx#223938</link><pubDate>Sun, 21 Dec 2008 20:18:52 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223938</guid><dc:creator>Pages tagged "cumulative"</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Pages tagged &amp;quot;cumulative&amp;quot;&lt;/p&gt;
&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223938" width="1" height="1"&gt;</description></item><item><title>Recent URLs tagged Redundancy - Urlrecorder</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/07/19/TestDisk-Data-Recovery-works-for-most-platforms.aspx#223927</link><pubDate>Thu, 04 Dec 2008 01:31:27 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223927</guid><dc:creator>Recent URLs tagged Redundancy - Urlrecorder</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Recent URLs tagged Redundancy - Urlrecorder&lt;/p&gt;
&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223927" width="1" height="1"&gt;</description></item><item><title>re: save $$ on your mobile with callback service from Hoiio</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/11/14/save-on-your-mobile-with-callback-service-from-hoiio.aspx#223898</link><pubDate>Thu, 13 Nov 2008 17:49:00 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223898</guid><dc:creator>darenhan</dc:creator><description>&lt;p&gt;videos:&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.youtube.com/watch?v=G_tCZjIOhN8"&gt;www.youtube.com/watch&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.youtube.com/watch?v=jwFJMaxkG_8"&gt;www.youtube.com/watch&lt;/a&gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223898" width="1" height="1"&gt;</description></item><item><title>re: Pitfall of storing dataset in a session variable</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/09/24/pitfall-of-storing-dataset-in-a-session-variable.aspx#223781</link><pubDate>Fri, 03 Oct 2008 03:19:26 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223781</guid><dc:creator>cruizer</dc:creator><description>&lt;p&gt;but yes, the app needs to be evaluated: does it really have to store all 60,000 rows in memory? most likely it doesn&amp;#39;t.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223781" width="1" height="1"&gt;</description></item><item><title>re: Pitfall of storing dataset in a session variable</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/09/24/pitfall-of-storing-dataset-in-a-session-variable.aspx#223780</link><pubDate>Fri, 03 Oct 2008 03:18:15 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223780</guid><dc:creator>cruizer</dc:creator><description>&lt;p&gt;@daren, well that means that RAM is the issue. storing a DataSet with 60,000 rows consumes a lot of RAM and it stressed out the server. but if the session store is in-process (within the ASP.NET handler), there is no &amp;quot;conversion&amp;quot; from a big session variable to a DataSet. the objects are stored as-is. conversion is only done if there is serialization involved, such as by having the StateServer or SQL Server as your session store.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223780" width="1" height="1"&gt;</description></item><item><title>re: Pitfall of storing dataset in a session variable</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/09/24/pitfall-of-storing-dataset-in-a-session-variable.aspx#223775</link><pubDate>Tue, 30 Sep 2008 14:41:30 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223775</guid><dc:creator>man_25</dc:creator><description>&lt;p&gt;Session is a light weight storage mechanism not intended for 60,000 rows! Also the session data must be serializable (or primitive data type) if StateServer is used. &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223775" width="1" height="1"&gt;</description></item><item><title>re: Pitfall of storing dataset in a session variable</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/09/24/pitfall-of-storing-dataset-in-a-session-variable.aspx#223770</link><pubDate>Mon, 29 Sep 2008 16:34:26 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223770</guid><dc:creator>darenhan</dc:creator><description>&lt;p&gt;nope, we did a test and monitor the memory usage during which we execute the code. It shoot up to 100% on the web server.&lt;/p&gt;
&lt;p&gt;sessions are supposed to be light weighted, not fit to store so much data inside.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223770" width="1" height="1"&gt;</description></item><item><title>re: Pitfall of storing dataset in a session variable</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/09/24/pitfall-of-storing-dataset-in-a-session-variable.aspx#223755</link><pubDate>Fri, 26 Sep 2008 04:01:29 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223755</guid><dc:creator>cruizer</dc:creator><description>&lt;p&gt;I think it will only be slow if the session is being stored out of process, like with an ASP.NET Session State server, or with SQL Server. But if the session storage is the built-in in-memory session store for ASP.NET, execution will be instantaneous.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223755" width="1" height="1"&gt;</description></item><item><title>Tommie</title><link>http://203.81.62.81/blogs/darenhan/archive/2007/01/19/Key-not-valid-for-use-in-specified-state-in-VS-2005-database-project.aspx#223566</link><pubDate>Fri, 08 Aug 2008 04:59:31 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223566</guid><dc:creator>Ryder</dc:creator><description>&lt;p&gt;6be0385b0640f3ef5a977671d9ec4081 &lt;/p&gt;
&lt;p&gt;&amp;lt;a href=&amp;quot;&lt;a rel="nofollow" target="_new" href="&lt;a rel="nofollow" target="_new" href="http://njdokj.info/3c681faa99b426ec510a5d3689fcd113/6be0385b0640f3ef5a977671d9ec4081"&gt;njdokj.info/.../6be0385b0640f3ef5a977671d9ec4081&lt;/a&gt;&amp;quot;&amp;gt;"&gt;njdokj.info/.../6be0385b0640f3ef5a977671d9ec4081&amp;quot;&amp;gt;&lt;/a&gt; &lt;a rel="nofollow" target="_new" href="http://njdokj.info/3c681faa99b426ec510a5d3689fcd113/6be0385b0640f3ef5a977671d9ec4081"&gt;njdokj.info/.../6be0385b0640f3ef5a977671d9ec4081&lt;/a&gt; &amp;lt;/a&amp;gt;&lt;/p&gt;
&lt;p&gt; &lt;a rel="nofollow" target="_new" href="http://njdokj.info/3c681faa99b426ec510a5d3689fcd113/6be0385b0640f3ef5a977671d9ec4081"&gt;njdokj.info/.../6be0385b0640f3ef5a977671d9ec4081&lt;/a&gt; &lt;/p&gt;
&lt;p&gt;[url]&lt;a rel="nofollow" target="_new" href="http://njdokj.info/3c681faa99b426ec510a5d3689fcd113/6be0385b0640f3ef5a977671d9ec4081"&gt;njdokj.info/.../6be0385b0640f3ef5a977671d9ec4081&lt;/a&gt;[url]&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223566" width="1" height="1"&gt;</description></item><item><title>free stock picks</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/07/09/Optimise-Cursors-in-Stored-Procedures.aspx#223482</link><pubDate>Sun, 03 Aug 2008 05:44:37 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223482</guid><dc:creator>WoorytopWaift</dc:creator><description>&lt;p&gt;Hi, &lt;/p&gt;
&lt;p&gt;I have been reading this blog for some time now but never bothered to comment until today. &amp;nbsp;Wanted to let you know that I am a fan and enjoy your work. &lt;/p&gt;
&lt;p&gt;Thanks, &lt;/p&gt;
&lt;p&gt;_________________ &lt;/p&gt;
&lt;p&gt;&amp;lt;a href=&lt;a rel="nofollow" target="_new" href="http://www.greencashmoney.com&amp;gt;Investor"&gt;http://www.greencashmoney.com&amp;gt;Investor&lt;/a&gt; Newsletter&amp;lt;/a&amp;gt; | &amp;lt;a href=&lt;a rel="nofollow" target="_new" href="http://www.greencashmoney.com&amp;gt;free"&gt;http://www.greencashmoney.com&amp;gt;free&lt;/a&gt; daily stock picks&amp;lt;/a&amp;gt; | &amp;lt;a href=&lt;a rel="nofollow" target="_new" href="http://www.greencashmoney.com&amp;gt;hot"&gt;http://www.greencashmoney.com&amp;gt;hot&lt;/a&gt; stock tips&amp;lt;/a&amp;gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223482" width="1" height="1"&gt;</description></item><item><title>Hugh</title><link>http://203.81.62.81/blogs/darenhan/archive/2006/11/17/49593.aspx#223419</link><pubDate>Mon, 28 Jul 2008 23:49:56 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223419</guid><dc:creator>Grady</dc:creator><description>&lt;p&gt;bb97db72cb21aa5ee98203c1d01be7b2 &lt;/p&gt;
&lt;p&gt;&amp;lt;a href=&amp;quot;&lt;a rel="nofollow" target="_new" href="&lt;a rel="nofollow" target="_new" href="http://njdokj.info/6f3845d35fe638659cc97c5153d4dae7/bb97db72cb21aa5ee98203c1d01be7b2"&gt;njdokj.info/.../bb97db72cb21aa5ee98203c1d01be7b2&lt;/a&gt;&amp;quot;&amp;gt;"&gt;njdokj.info/.../bb97db72cb21aa5ee98203c1d01be7b2&amp;quot;&amp;gt;&lt;/a&gt; &lt;a rel="nofollow" target="_new" href="http://njdokj.info/6f3845d35fe638659cc97c5153d4dae7/bb97db72cb21aa5ee98203c1d01be7b2"&gt;njdokj.info/.../bb97db72cb21aa5ee98203c1d01be7b2&lt;/a&gt; &amp;lt;/a&amp;gt;&lt;/p&gt;
&lt;p&gt; &lt;a rel="nofollow" target="_new" href="http://njdokj.info/6f3845d35fe638659cc97c5153d4dae7/bb97db72cb21aa5ee98203c1d01be7b2"&gt;njdokj.info/.../bb97db72cb21aa5ee98203c1d01be7b2&lt;/a&gt; &lt;/p&gt;
&lt;p&gt;[url]&lt;a rel="nofollow" target="_new" href="http://njdokj.info/6f3845d35fe638659cc97c5153d4dae7/bb97db72cb21aa5ee98203c1d01be7b2"&gt;njdokj.info/.../bb97db72cb21aa5ee98203c1d01be7b2&lt;/a&gt;[url]&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223419" width="1" height="1"&gt;</description></item><item><title>re: layman explainations behind the cryptic dot net error message</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/04/29/layman-explainations-behind-the-cryptic-dot-net-error-message.aspx#223380</link><pubDate>Sat, 26 Jul 2008 10:23:50 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223380</guid><dc:creator>kocgeykislb</dc:creator><description>&lt;p&gt;bDy05z &amp;nbsp;&amp;lt;a href=&amp;quot;&lt;a rel="nofollow" target="_new" href="http://aslgmdtsgxly.com/&amp;quot;&amp;gt;aslgmdtsgxly&amp;lt;/a&amp;gt;"&gt;aslgmdtsgxly.com/.../a&amp;gt;&lt;/a&gt;, [url=&lt;a rel="nofollow" target="_new" href="http://aovbyxvqdaqt.com/"&gt;http://aovbyxvqdaqt.com/&lt;/a&gt;]aovbyxvqdaqt[/url], [link=&lt;a rel="nofollow" target="_new" href="http://exxdaqcxwekf.com/"&gt;http://exxdaqcxwekf.com/&lt;/a&gt;]exxdaqcxwekf[/link], &lt;a rel="nofollow" target="_new" href="http://ixsfjzzssplh.com/"&gt;http://ixsfjzzssplh.com/&lt;/a&gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223380" width="1" height="1"&gt;</description></item><item><title>flow1800</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/04/29/layman-explainations-behind-the-cryptic-dot-net-error-message.aspx#223262</link><pubDate>Mon, 21 Jul 2008 18:12:04 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223262</guid><dc:creator>flow1800</dc:creator><description>&lt;p&gt;dskn2E gihiroef jsgiosjiogjdso igjiosdjgiodsg jwguj 94wjsdfkj gkjgl4wg dsgds&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223262" width="1" height="1"&gt;</description></item><item><title>re: TestDisk Data Recovery works for most platforms</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/07/19/TestDisk-Data-Recovery-works-for-most-platforms.aspx#223256</link><pubDate>Mon, 21 Jul 2008 07:52:08 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:223256</guid><dc:creator>Hannes</dc:creator><description>&lt;p&gt;Yep it is good, this was the only software of many that was able to repair a partition. That after some other tools actually caused a complete &amp;quot;loss&amp;quot; of all files while trying to fix boot sector.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=223256" width="1" height="1"&gt;</description></item><item><title>re: Another fire-fighting case due to "cut costs"</title><link>http://203.81.62.81/blogs/darenhan/archive/2008/02/03/Another-fire_2D00_fighting-case-due-to-_2200_cut-costs_2200_.aspx#222263</link><pubDate>Wed, 09 Jul 2008 14:43:37 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:222263</guid><dc:creator>darenhan</dc:creator><description>&lt;p&gt;Adapted from Sizing and deployment guide of Crystal Enterprise 10:&lt;/p&gt;
&lt;p&gt;&amp;quot;For production environments, it is recommended that the CMS database not be placed on:&lt;/p&gt;
&lt;p&gt;1) The database server against which the reports are running&lt;/p&gt;
&lt;p&gt;2) Any one of the Job Server or Page Server machines&lt;/p&gt;
&lt;p&gt;3) One of the CMS machines.&lt;/p&gt;
&lt;p&gt;The reason for this is that if the Database Server, Job Server, or Page Server is busy processing the&lt;/p&gt;
&lt;p&gt;data for reports, the retrieval time for the CMS to query the same server will be negatively&lt;/p&gt;
&lt;p&gt;impacted. Please refer to the Crystal Enterprise Installation guide for information on supported&lt;/p&gt;
&lt;p&gt;CMS databases.&amp;quot;&lt;/p&gt;
&lt;p&gt;Currently, in our Prod server, the ce10 which is the CMS database is situated &lt;/p&gt;
&lt;p&gt;on the same database server. &lt;/p&gt;
&lt;p&gt;An irony which contradicts with the deployment and sizing guide of crystal enterprise 10 guide from BusinessObjects. lolz&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://203.81.62.81/aggbug.aspx?PostID=222263" width="1" height="1"&gt;</description></item></channel></rss>