<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="rss.xsl" media="screen"?>
<rss version="2.0">
  <channel>
    <title>微软BI开拓者 - 最新空间日志</title>
    <link>http://www.windbi.com/spaceindex.aspx</link>
    <description>Latest 20 blogs</description>
    <copyright>Copyright (c) 微软BI开拓者</copyright>
    <generator>Discuz!NT</generator>
    <pubDate>Wed, 08 Feb 2012 06:45:53 GMT</pubDate>
    <ttl>60</ttl>
    <item>
      <title>SQL Server 2011新特点：包容数据库</title>
      <description><![CDATA[SQL Server 2011新特点：包容数据库--王成辉翻译整理，转贴请注明出自微软BI开拓者www.windbi.com--原帖地址SQL Server 2011也即SQL Server Denali引入了一个新的特点称作包容数据库。一个包容数据库基本上包括了自身需要的所有数据库的设置和元数据，因此对SQL Server数据库引擎没有配置上的依赖。用户可以在没有数据库引擎级的login验证的情]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=385</link>
      <category></category>
      <author>拓狼</author>
      <pubDate>Fri, 22 Jul 2011 06:19:24 GMT</pubDate>
    </item>
    <item>
      <title>get the top-10 queries that are taking the most CPU</title>
      <description><![CDATA[SELECT TOP 10&amp;nbsp;&amp;nbsp; total_worker_time/execution_count AS avg_cpu_cost, plan_handle,&amp;nbsp;&amp;nbsp; execution_count,&amp;nbsp;&amp;nbsp; (SELECT SUBSTRING(text, statement_start_offset/2 + 1,&amp;nbsp;&amp;nbsp;&amp;nbs......]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=383</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Wed, 09 Jun 2010 02:04:02 GMT</pubDate>
    </item>
    <item>
      <title>Figure out which databases involve most of the I/O and I/O s</title>
      <description><![CDATA[WITH DBIO AS(&amp;nbsp; SELECT&amp;nbsp;&amp;nbsp;&amp;nbsp; DB_NAME(IVFS.database_id) AS db,&amp;nbsp;&amp;nbsp;&amp;nbsp; CASE WHEN MF.type = 1 THEN 'log' ELSE 'data' END AS file_type,&amp;nbsp;&amp;nbsp;&amp;nbsp; SUM(IVFS.num_of_bytes_r......]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=382</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Wed, 12 May 2010 02:06:19 GMT</pubDate>
    </item>
    <item>
      <title>How to isolate the top waits for sqlserver</title>
      <description><![CDATA[WITH Waits AS
(
  SELECT
    wait_type,
    wait_time_ms / 1000. AS wait_time_s,
    100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct,
    ROW_NUMBER() OVER(ORDER BY wait_time_ms DESC) AS r]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=381</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Tue, 11 May 2010 21:43:17 GMT</pubDate>
    </item>
    <item>
      <title>Split A String Into A Table</title>
      <description><![CDATA[declare @TableStr varchar(max)Declare @SplitStr VARCHAR(1)
Set @TableStr='AIU;Aptimus;CTU;Datamark;Eminata;IADT;Kaplan;Triad;'SET @SplitStr=';'
SELECT SUBSTRING((@SplitStr+@TableStr+@SplitStr),n.num......]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=380</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Wed, 07 Apr 2010 22:02:19 GMT</pubDate>
    </item>
    <item>
      <title>Summary A String Column</title>
      <description><![CDATA[declare @Result nvarchar(max)
Set @Result=''
select @Result=@Result+';'+StringColumn from TableName order by SomeColumn
select @Result]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=379</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Wed, 07 Apr 2010 21:12:25 GMT</pubDate>
    </item>
    <item>
      <title>Get A  Random Integer</title>
      <description><![CDATA[select cast(rand()*N as int) 
&amp;nbsp;
when N&amp;gt;0, The data range is between 0 and N-1
when N&amp;lt;0, the data range is between&amp;nbsp;N and&amp;nbsp; -1]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=378</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Wed, 31 Mar 2010 02:18:51 GMT</pubDate>
    </item>
    <item>
      <title>Get the row count and data size of all tables</title>
      <description><![CDATA[declare @spacetable table(&amp;nbsp;&amp;nbsp;&amp;nbsp; name nvarchar(255)&amp;nbsp;&amp;nbsp;&amp;nbsp;,rows int&amp;nbsp;&amp;nbsp;&amp;nbsp;,reserved nvarchar(255)&amp;nbsp;&amp;nbsp;&amp;nbsp;,data nvarchar(255)&amp;nbsp;&amp;nbsp;&amp;nbsp;,index_size nv......]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=377</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Tue, 30 Mar 2010 02:13:51 GMT</pubDate>
    </item>
    <item>
      <title>USE CTE ORDER Department For TreeView</title>
      <description><![CDATA[
SET NOCOUNT ON;
USE tempdb;
GO
IF OBJECT_ID('dbo.Employees') IS NOT NULL
&amp;nbsp; DROP TABLE dbo.Employees;
GO
CREATE TABLE dbo.Employees
(
&amp;nbsp; id&amp;nbsp;&amp;nbsp; INT&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nb......]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=376</link>
      <category></category>
      <author>seawater001</author>
      <pubDate>Thu, 25 Mar 2010 02:28:40 GMT</pubDate>
    </item>
    <item>
      <title>回复：我的原创整理请大家指教 第一篇 SQL 与 CPU (续篇,重编译)</title>
      <description><![CDATA[1 引起编译重编译的原因A 架构变化B 统计变化C 延期编译D Set属性改变E 临时表改变F 存储过程创建时使用了RECOMPLIE查询提示或使用了OPTION （RECOMPILE）。2 通过系统计数器监视A SQL Statistics : SQL Recompilations/sec和Batch Request/sec的比值应该很低，除非用户提交了大量的单独查询。B SQL Server:]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=371</link>
      <category></category>
      <author>caierjia</author>
      <pubDate>Tue, 31 Mar 2009 16:28:35 GMT</pubDate>
    </item>
    <item>
      <title>欢迎使用 微软BI开拓者 个人空间</title>
      <description><![CDATA[????????]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=370</link>
      <category></category>
      <author>caierjia</author>
      <pubDate>Tue, 31 Mar 2009 16:28:35 GMT</pubDate>
    </item>
    <item>
      <title>在SSAS中的数据源视图中添加命名计算的问题</title>
      <description><![CDATA[在数据源视图中添加命名计算，想新添加一个计算列，通过使用CASE语句手动地离散化另一个连续的数值列。但是始终要报个错：“ 出现以下系统错误:&amp;nbsp; 帐户名与安全标识间无任何映射完成”？ 如图：[attachimg]758[/attachimg]这个解决方案是我从网上下载的一个案例，其实每当我把一台机器上的SSAS解决方案移到另一台机器上时都会发生这个问题，不知道是什么原因我这个CASE语句是]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=367</link>
      <category></category>
      <author>YinPSoft</author>
      <pubDate>Wed, 26 Nov 2008 18:18:16 GMT</pubDate>
    </item>
    <item>
      <title>欢迎使用 微软BI开拓者 个人空间</title>
      <description><![CDATA[????????]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=366</link>
      <category></category>
      <author>YinPSoft</author>
      <pubDate>Wed, 26 Nov 2008 18:18:16 GMT</pubDate>
    </item>
    <item>
      <title>欢迎使用 微软BI开拓者 个人空间</title>
      <description><![CDATA[????????]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=313</link>
      <category></category>
      <author>lcgyjyb</author>
      <pubDate>Fri, 18 Jul 2008 13:54:14 GMT</pubDate>
    </item>
    <item>
      <title>在ssas中如何使用貨幣轉換?</title>
      <description><![CDATA[在ssas中如何使用貨幣轉換?請各位高手指點﹐轉換類型是多對多的﹐即事實表有多幣別﹐希望能通過轉換后﹐可以by 所有幣別看到資料。也可以通過QQ790981002討論﹐謝謝 ﹗]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=209</link>
      <category></category>
      <author>Sprina_liu</author>
      <pubDate>Wed, 25 Jun 2008 11:56:42 GMT</pubDate>
    </item>
    <item>
      <title>欢迎使用 微软BI开拓者 个人空间</title>
      <description><![CDATA[????????]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=208</link>
      <category></category>
      <author>Sprina_liu</author>
      <pubDate>Wed, 25 Jun 2008 11:56:42 GMT</pubDate>
    </item>
    <item>
      <title>[转贴]80后一买房就变成了50后</title>
      <description><![CDATA[原url:http://blog.sina.com.cn/s/blog_473abae601000ecv.html &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;  80后一买房就变成了50后&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;n]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=46</link>
      <category></category>
      <author>Administrator</author>
      <pubDate>Fri, 16 May 2008 10:10:32 GMT</pubDate>
    </item>
    <item>
      <title>欢迎使用 微软BI开拓者 空间</title>
      <description><![CDATA[????????]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=45</link>
      <category></category>
      <author>Administrator</author>
      <pubDate>Fri, 16 May 2008 10:10:32 GMT</pubDate>
    </item>
    <item>
      <title>[转贴]80后一买房就变成了50后</title>
      <description><![CDATA[原url:http://blog.sina.com.cn/s/blog_473abae601000ecv.html &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;  80后一买房就变成了50后&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;n]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=44</link>
      <category></category>
      <author>Administrator</author>
      <pubDate>Fri, 16 May 2008 10:10:31 GMT</pubDate>
    </item>
    <item>
      <title>欢迎使用 微软BI开拓者 空间</title>
      <description><![CDATA[????????]]></description>
      <link>http://www.windbi.com/space/viewspacepost.aspx?postid=43</link>
      <category></category>
      <author>Administrator</author>
      <pubDate>Fri, 16 May 2008 10:10:31 GMT</pubDate>
    </item>
  </channel>
</rss>
