摘要： Analysis Services does not have "alert" functionality. SSAS cannot send e-mail, so your best bet is to delegate that functionality somewhere else. My suggestion was to use SQL Server. Here are sample ... 阅读全文

摘要： SQL Server Analysis Services Port (SQL 2005 / 2008) karang 5 Sep 2009 4:33 AM Default Port:2383You can change default Port for AS in msmdsrv.ini file of the Instance.Port Used by SQL Server Browser Se... 阅读全文

摘要： SQL Server访问远程数据库和Linked ServerSQL Server连接远程数据源的基本方法有下面三种：OPENDATASOURCE: The OPENDATASOURCE function is used to specify connection information for a remote data source by specifying the OLE DB provi... 阅读全文

摘要： Handling workloads on SQL Server 2008 with Resource GovernorWritten By: Arshad Ali -- 4/1/2009 ProblemHandling workloads has been quite difficult until SQL Server 2005. For example consider a scenario... 阅读全文

摘要： http://msdn.microsoft.com/en-us/library/ms181714.aspxSyntax Arguments { HASH | ORDER } GROUP Specifies that aggregations described in the GROUP BY, DISTINCT, or COMPUTE clause of the query should use... 阅读全文

摘要： 释放SQL Server占用的内存2009年9月1日 看看评论 评论一个 由于Sql Server对于系统内存的管理策略是有多少占多少，除非系统内存不够用了（大约到剩余内存为4M左右），Sql Server才会释放一点点内存。所以很多时候，我们会发现运行Sql Server的系统内存往往居高不下。这些内存一般都是Sql Server运行时候用作缓存的，例如你运行一个select语句，那么Sql S... 阅读全文

摘要： Implementing Office Web Component Pivot Tables with ASP.NETby Eric CharranIntroductionA short time after Office 2000 debuted, many developers began to recognize the power of Office Web components. Dur... 阅读全文

摘要： 大地震前有三个明显征兆：1.井水异常2.牲畜反应异常3.专家出来辟谣。但是细心网友指出，第三和第二重复了。 阅读全文

摘要： http://www.ssas-info.com/analysis-services-faq/27-mdx 阅读全文

摘要： MDX-How can I get attribute key with MDX Written by Ramunas Balukonis Monday, 11 June 2007 06:38 Q: How can I get attribute key with MDXA: To do so, use Member_Key function:WITHMEMBER Measures.Produc... 阅读全文