<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://geeks.netindonesia.net/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>SQL Server knowledge center - All Comments</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/default.aspx</link><description>everything about SQL Server</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator><item><title>beauty:design:life: Ms. JD: Networking on a Budget | Business Beauty Wisdom</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/01/26/database-integrity-check-with-smo.aspx#185801</link><pubDate>Sun, 07 Feb 2010 21:44:27 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:185801</guid><dc:creator>beauty:design:life: Ms. JD: Networking on a Budget | Business Beauty Wisdom</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;beauty:design:life: Ms. JD: Networking on a Budget | Business Beauty Wisdom&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=185801" width="1" height="1"&gt;</description></item><item><title>Twitter Trackbacks for                 Database Integrity Check with SMO - SQL Server knowledge center         [netindonesia.net]        on Topsy.com</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/01/26/database-integrity-check-with-smo.aspx#185653</link><pubDate>Fri, 29 Jan 2010 07:30:01 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:185653</guid><dc:creator>Twitter Trackbacks for                 Database Integrity Check with SMO - SQL Server knowledge center         [netindonesia.net]        on Topsy.com</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Twitter Trackbacks for &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Database Integrity Check with SMO - SQL Server knowledge center &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; [netindonesia.net] &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;on Topsy.com&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=185653" width="1" height="1"&gt;</description></item><item><title>Get List of SQL Server Instances with SMO - SQL Server knowledge &amp;#8230; Mobile</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/01/17/get-list-of-sql-server-instances-with-smo.aspx#185478</link><pubDate>Sun, 17 Jan 2010 12:42:02 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:185478</guid><dc:creator>Get List of SQL Server Instances with SMO - SQL Server knowledge … Mobile</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Get List of SQL Server Instances with SMO - SQL Server knowledge &amp;amp;#8230; Mobile&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=185478" width="1" height="1"&gt;</description></item><item><title>Looking Inside SQL Server Data Row for Variable Length Column</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/12/22/looking-inside-sql-server-data-row.aspx#184966</link><pubDate>Tue, 29 Dec 2009 22:45:28 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184966</guid><dc:creator>SQL Server knowledge center</dc:creator><description>&lt;p&gt;Looking Inside SQL Server Data Row for Variable Length Column By : Kasim Wirama, MCITP, MCDBA I have&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184966" width="1" height="1"&gt;</description></item><item><title>Looking Inside SQL Server Data Row</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/12/20/examining-sql-server-data-page-via-undocumented-dbcc-command.aspx#184859</link><pubDate>Tue, 22 Dec 2009 11:43:34 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184859</guid><dc:creator>SQL Server knowledge center</dc:creator><description>&lt;p&gt;Looking Inside SQL Server Data Row By : Kasim Wirama, MCITP, MCDBA If you have read my 2 previous postings&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184859" width="1" height="1"&gt;</description></item><item><title>Transaction Log Fragmentation???</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/11/02/internal-fragmentation-on-sql-server-transaction-log.aspx#184803</link><pubDate>Thu, 17 Dec 2009 23:27:59 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184803</guid><dc:creator>DBA Tipster</dc:creator><description>&lt;p&gt;Did you realize that transaction logs can be fragmented?&amp;amp;#160; Well, not only can your transaction logs&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184803" width="1" height="1"&gt;</description></item><item><title>Behind Detach-Attach SQL Server Database &amp;#8211; SQL Server knowledge center</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/12/14/behind-detach-attach-sql-server-database.aspx#184779</link><pubDate>Tue, 15 Dec 2009 22:43:12 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184779</guid><dc:creator>Behind Detach-Attach SQL Server Database – SQL Server knowledge center</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Behind Detach-Attach SQL Server Database &amp;amp;#8211; SQL Server knowledge center&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184779" width="1" height="1"&gt;</description></item><item><title>Never Underestimate the Power of a Brand | Franchise Money Maker | Promotional Content Marketing Wisdom</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/12/13/objects-in-tempdb.aspx#184777</link><pubDate>Tue, 15 Dec 2009 11:21:36 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184777</guid><dc:creator>Never Underestimate the Power of a Brand | Franchise Money Maker | Promotional Content Marketing Wisdom</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Never Underestimate the Power of a Brand | Franchise Money Maker | Promotional Content Marketing Wisdom&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184777" width="1" height="1"&gt;</description></item><item><title>re: Behind Detach-Attach SQL Server Database</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/12/14/behind-detach-attach-sql-server-database.aspx#184763</link><pubDate>Mon, 14 Dec 2009 21:34:15 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184763</guid><dc:creator>Kasim.Wirama</dc:creator><description>&lt;p&gt;You can query to system catalogue view : select is_read_only from sys.databases&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184763" width="1" height="1"&gt;</description></item><item><title>re: Behind Detach-Attach SQL Server Database</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/12/14/behind-detach-attach-sql-server-database.aspx#184760</link><pubDate>Mon, 14 Dec 2009 13:37:55 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184760</guid><dc:creator>adi.trim</dc:creator><description>&lt;p&gt;so ... how to get information about that the databases is readonly or read/write ?&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184760" width="1" height="1"&gt;</description></item><item><title>Thresholds &amp;amp; Managing Application Performance Proactively | appmanager | Enterprise IT Management, Network performance management, IT Servicedesk, Desktop Management, Datacenter Management,  Server Management, Log Analysis and Security Management, </title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/02/19/list-of-threshold-value-for-sql-server-performance-counters.aspx#184619</link><pubDate>Mon, 30 Nov 2009 14:19:28 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184619</guid><dc:creator>Thresholds &amp; Managing Application Performance Proactively | appmanager | Enterprise IT Management, Network performance management, IT Servicedesk, Desktop Management, Datacenter Management,  Server Management, Log Analysis and Security Management, Network Tools, ManageEngine Blogs</dc:creator><description>&lt;p&gt;Pingback from &amp;nbsp;Thresholds &amp;amp;amp; Managing Application Performance Proactively | appmanager | Enterprise IT Management, Network performance management, IT Servicedesk, Desktop Management, Datacenter Management, &amp;nbsp;Server Management, Log Analysis and Security Management, Network Tools, ManageEngine Blogs&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184619" width="1" height="1"&gt;</description></item><item><title>re: Viewing Big Data in Excel 2007</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/07/21/viewing-big-data-in-excel-2007.aspx#184590</link><pubDate>Wed, 25 Nov 2009 14:42:30 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:184590</guid><dc:creator>sfqfirst</dc:creator><description>&lt;p&gt;SSIS is poorer.It will possible happen:first is cut 255 characters,second is can not get all Excel sheets,third is can not get correct column when the column both includes text and number datatypes.&lt;/p&gt;
&lt;p&gt;You may try &amp;quot;Atolva MapForce&amp;quot;,it compiles output original INSERT INTO sql clauses,and works good.&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=184590" width="1" height="1"&gt;</description></item><item><title>Table-Valued Paramaters</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/07/27/passing-table-valued-parameter-using-ado-net.aspx#183702</link><pubDate>Wed, 23 Sep 2009 03:14:30 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:183702</guid><dc:creator>Suherman</dc:creator><description>&lt;p&gt;Setiap Developer or DBA pasti setuju untuk sebisa mungkin meminimalisasi terjadinya round trips antara&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=183702" width="1" height="1"&gt;</description></item><item><title>OUTPUT…INTO… Extension in SQL Server 2008 MERGE Statement</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/07/22/merge-statement-in-sql-server-2008.aspx#182906</link><pubDate>Thu, 30 Jul 2009 09:32:04 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:182906</guid><dc:creator>SQL Server knowledge center</dc:creator><description>&lt;p&gt;OUTPUT…INTO… Extension in SQL Server 2008 MERGE Statement By : Kasim Wirama, MCITP, MCDBA If you read&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=182906" width="1" height="1"&gt;</description></item><item><title>Solution for Blocking Problem in SQL Server 2005/2008</title><link>http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2009/07/22/detect-database-blocking-issue-with-sql-server-dynamic-management-view.aspx#182903</link><pubDate>Thu, 30 Jul 2009 09:10:23 GMT</pubDate><guid isPermaLink="false">5cc3a90d-ac9a-472a-8983-30514957434c:182903</guid><dc:creator>SQL Server knowledge center</dc:creator><description>&lt;p&gt;Solution for Blocking Problem in SQL Server 2005/2008 By : Kasim Wirama, MCITP, MCDBA If you read my&lt;/p&gt;
&lt;img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=182903" width="1" height="1"&gt;</description></item></channel></rss>