http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspxSome customers have asked why some tables in the star-schema database have indexes and others don't. As suggested by SQL Books Online “Creating and Using Data Warehouses”, all the dimension tables have the index automatically created on the primary keyen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#443656Wed, 27 Jul 2005 04:02:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:443656Paul MooneyBecome part of the BizTalk Server 2006 Beta Team and get BizTalk Server 2006 Beta 1. BizTalk Server 2006...http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#510211Fri, 06 Jan 2006 23:12:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:510211Vamsihttp://vamsibiztalk.blogspot.com/ I have posted some of your queries in my blog, as well as all BAM queries, regards Vamsihttp://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9688781Wed, 03 Jun 2009 05:38:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:9688781 BAM BizTalk and Beyond Indexes in the BAM star schema database | Patio Chairs<p>PingBack from <a rel="nofollow" target="_new" href="http://patiochairsite.info/story.php?id=30143">http://patiochairsite.info/story.php?id=30143</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9750258Sun, 14 Jun 2009 16:08:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:9750258 BAM BizTalk and Beyond Indexes in the BAM star schema database | adirondack chairs<p>PingBack from <a rel="nofollow" target="_new" href="http://adirondackchairshub.info/story.php?id=803">http://adirondackchairshub.info/story.php?id=803</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9763835Wed, 17 Jun 2009 04:33:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:9763835 BAM BizTalk and Beyond Indexes in the BAM star schema database | fix my credit<p>PingBack from <a rel="nofollow" target="_new" href="http://fixmycrediteasily.info/story.php?id=7639">http://fixmycrediteasily.info/story.php?id=7639</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9771717Thu, 18 Jun 2009 05:14:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:9771717 BAM BizTalk and Beyond Indexes in the BAM star schema database | patio set<p>PingBack from <a rel="nofollow" target="_new" href="http://patiosetsite.info/story.php?id=260">http://patiosetsite.info/story.php?id=260</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9772278Thu, 18 Jun 2009 06:46:54 GMT91d46819-8472-40ad-a661-2c78acb4018c:9772278 BAM BizTalk and Beyond Indexes in the BAM star schema database | patio umbrella<p>PingBack from <a rel="nofollow" target="_new" href="http://patioumbrellasource.info/story.php?id=796">http://patioumbrellasource.info/story.php?id=796</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9780519Fri, 19 Jun 2009 09:30:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:9780519 BAM BizTalk and Beyond Indexes in the BAM star schema database | bar stools<p>PingBack from <a rel="nofollow" target="_new" href="http://barstoolsite.info/story.php?id=2606">http://barstoolsite.info/story.php?id=2606</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9781339Fri, 19 Jun 2009 10:05:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:9781339 BAM BizTalk and Beyond Indexes in the BAM star schema database | garden decor<p>PingBack from <a rel="nofollow" target="_new" href="http://gardendecordesign.info/story.php?id=5116">http://gardendecordesign.info/story.php?id=5116</a></p> http://blogs.msdn.com/chunyu/archive/2005/07/19/440509.aspx#9782111Fri, 19 Jun 2009 10:41:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:9782111 BAM BizTalk and Beyond Indexes in the BAM star schema database | porch swing<p>PingBack from <a rel="nofollow" target="_new" href="http://fancyporchswing.info/story.php?id=602">http://fancyporchswing.info/story.php?id=602</a></p>