<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://community.sgdotnet.org/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/" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd"><channel><title>DarenHan's Blog - All Comments</title><link>http://community.sgdotnet.org/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>re: Norton 2010 Launch Event</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2009/10/08/norton-2010-launch-event.aspx#224490</link><pubDate>Wed, 18 Nov 2009 12:48:29 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224490</guid><dc:creator>darenhan</dc:creator><description>&lt;p&gt;To register for such events:&lt;/p&gt;
&lt;p&gt;&lt;a rel="nofollow" target="_new" href="http://www.nortonopscenter.com/asean/nic/member.html"&gt;www.nortonopscenter.com/.../member.html&lt;/a&gt;&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224490" width="1" height="1"&gt;</description></item><item><title>BenjaminBoyle.com      &amp;raquo; Blog Archive           &amp;raquo; Cannot create trigger  because its schema is different from the schema of the target table or view</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2007/02/07/Unable-to-enable-SQL-Cache-dependency-for-tables-with-schema_2E00_.aspx#224470</link><pubDate>Wed, 28 Oct 2009 21:43:50 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224470</guid><dc:creator>BenjaminBoyle.com      » Blog Archive           » Cannot create trigger  because its schema is different from the schema of the target table or view</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;BenjaminBoyle.com &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;raquo; Blog Archive &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;raquo; Cannot create trigger &amp;nbsp;because its schema is different from the schema of the target table or view&lt;/p&gt;
&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224470" width="1" height="1"&gt;</description></item><item><title>re: SQL Server 2000 suspect database status</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2009/05/20/sql-server-2000-suspect-database-status.aspx#224299</link><pubDate>Tue, 26 May 2009 15:41:29 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224299</guid><dc:creator>darenhan</dc:creator><description>&lt;p&gt;I found I have to restart the sql agent after doing the above steps. &lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224299" width="1" height="1"&gt;</description></item><item><title>classic asp memory leaks in IIS | Daniel Friedmann</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2007/10/29/How-to-solve-memory-leak-in-IIS-w3p.exe.aspx#224213</link><pubDate>Fri, 10 Apr 2009 19:44:14 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224213</guid><dc:creator>classic asp memory leaks in IIS | Daniel Friedmann</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;classic asp memory leaks in IIS | Daniel Friedmann&lt;/p&gt;
&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224213" width="1" height="1"&gt;</description></item><item><title>Bookmarks about Tutorials</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2008/07/17/OSCON-2008-registration-is-now-open.aspx#224121</link><pubDate>Wed, 25 Feb 2009 06:15:25 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224121</guid><dc:creator>Bookmarks about Tutorials</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Bookmarks about Tutorials&lt;/p&gt;
&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224121" width="1" height="1"&gt;</description></item><item><title>Recent Faves Tagged With "duplicate" : MyNetFaves</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2008/08/17/make-your-pdfs-smaller.aspx#224102</link><pubDate>Wed, 18 Feb 2009 03:35:35 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224102</guid><dc:creator>Recent Faves Tagged With "duplicate" : MyNetFaves</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Recent Faves Tagged With &amp;quot;duplicate&amp;quot; : MyNetFaves&lt;/p&gt;
&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224102" width="1" height="1"&gt;</description></item><item><title>re: Tip for iphone users 2.2 - how to enable emoji emoticons the legal way.</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2009/01/24/tip-for-iphone-users-2-2-how-to-enable-emoji-emoticons-the-legal-way.aspx#224053</link><pubDate>Sat, 24 Jan 2009 02:23:06 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224053</guid><dc:creator>darenhan</dc:creator><description>&lt;p&gt;for $0.99 it is quite a good deal.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224053" width="1" height="1"&gt;</description></item><item><title>User links about "testdisk" on iLinkShare</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2008/07/19/TestDisk-Data-Recovery-works-for-most-platforms.aspx#224051</link><pubDate>Fri, 23 Jan 2009 05:18:04 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224051</guid><dc:creator>User links about "testdisk" on iLinkShare</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;User links about &amp;quot;testdisk&amp;quot; on iLinkShare&lt;/p&gt;
&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224051" width="1" height="1"&gt;</description></item><item><title>importing asp.net membership tables | keyongtech</title><link>http://community.sgdotnet.org/blogs/darenhan/archive/2006/11/17/49593.aspx#224043</link><pubDate>Thu, 22 Jan 2009 01:42:07 GMT</pubDate><guid isPermaLink="false">9f588fb1-4571-42db-9419-e7c908124e96:224043</guid><dc:creator>importing asp.net membership tables | keyongtech</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;importing asp.net membership tables | keyongtech&lt;/p&gt;
&lt;img src="http://community.sgdotnet.org/aggbug.aspx?PostID=224043" width="1" height="1"&gt;</description></item><item><title>Pages tagged "cumulative"</title><link>http://community.sgdotnet.org/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://community.sgdotnet.org/aggbug.aspx?PostID=223938" width="1" height="1"&gt;</description></item><item><title>Recent URLs tagged Redundancy - Urlrecorder</title><link>http://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/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://community.sgdotnet.org/aggbug.aspx?PostID=223775" width="1" height="1"&gt;</description></item></channel></rss>