-
编辑 删除
Memory re-allocation
Control Panel - > System and Security - > System - > Advanced System Settings - > Performance - > Settings -> Advanced - > Change - > Custom SizeInitial SizeMaximum sizeset and then...
-
编辑 删除
Swap file
在run ssis package时，报错The buffer managercannot extend the file"C:\Windos\SERVIC~2\NETWOR~1\AppData\Local\Temp\DTS{B4AD63C5-5B02-40A8-BD15-3ABBCD15409D}.tmp"to length 10479136 bytes. There...
-
编辑 删除
合并文本字符串
concatenate 函数可以用来合并几个单元格内的文本字符。EX:=concatenate(A1,A2)
-
编辑 删除
Run as different user
win7中，按住shift键，右键单击项目，即可出现' Run as different user' 选项。
-
编辑 删除
Add line numbers in SQL SERVER text Editor
Tools - > Options - > Text Editor -> All Languages -> Click Display 'Line numbers'
-
编辑 删除
Excel define List name and data Validation
1. define a list in the excel, choose the cell range and right click to choose 'define name', then a list is created.2. click on the cell, data panel , choose validation , then source in...
-
编辑 删除
RS Performance Issue on MDX - (1)
When it comes to the performance issue with the reports, subcube is always a solution for that. For instance, if the reports contains 2 dates filter in the where slice, it should be very ...
-
编辑 删除
Repeat Tablix Row Header on each page
GettingSSRS 2008 to repeat the Tablix header is not a straight forward setting andrequires some additional steps to do so.Thisused to be very simple thing till SSRS 2005, there basicall...
-
编辑 删除
Kimball Method Slowly Changing Dimension
The Slowly Changing Dimension Transformation could be in use in SSIS for the ETL process . SSIS coordinates the updating and inserting of records in data warehouse dimen...
-
编辑 删除
Binary Data Type
binary不接收字符串, 但可以先把字符串转为binarydeclare @bi binary(8)set @bi=cast('12' as binary(8))select @bi--output 0x3132000000000000 因此在where子句中，不能用字符串查询。例：如果Tabl...
-
编辑 删除
SSRS Access Permission Error on Windows 7
One of my colleagues is self-studying the SQL SERVER 2008, especially for SASS and SSRS, today he uncounted a problem of ‘access Permission’ issue for SSRS when routing to http://localhost/Repo...
-
编辑 删除
SQL SERVER Performance Issue
Sometimes, the memory is the bottleneck while we processing the cubes. When the windows server memory goes up, if we restart the sql server, issue will be gone.
-
编辑 删除
Some points in ETL
From : 【1】http://intelligent-enterprise.informationweek.com/showArticle.jhtml;jsessionid=104LBVB3GJ2MJQE1GHPSKHWATMY32JVN?articleID=220600174&pgno=1【2】http://blog.csdn.net/wsbupt/archive/2009/12...
-
编辑 删除
Testing Cubes in BI Projects using Excel
Recently, am involved in the BI projects testing activities. Basically, the main task is the data comparison between data in database(Source data) and the data out of our cubes (Target data). &n...
-
编辑 删除
Format data with fixed decimals in excel
Round function returns a number rounded to a specified number of digits. Example: Round(7.3333, 2) = 7.33
-
编辑 删除
Remove spaces inside the Cell in Excel
Trim The Trim function returns a text value with the leading and trailing spaces removed.Example: = Trim (A1) SubstituteSubstitute function replaces a set of characters with another. ...
-
编辑 删除
Post Mortem
It is the conclusion of the project, usually comes at the end of the project. Normally it includes the hilights and lowlights.
-
编辑 删除
Bug Triage
The bug triage process enables your team to identify and classify bugs for the purpose of fixing and resolving them.缺陷类选决定哪个缺陷需要被修复的过程。通常会包括定义缺陷修复的优先级。...
-
编辑 删除
Analysis Services 2005/2008 Command-line Utility ascmd.exe
For my previous two projects, the deployment of the BI project are varied.It is interesting that now am doing my third BI project on SQL Server and I got a easier way. First One: &...
-
编辑 删除
Many-to-Many Dimensions in Analysis Services 2005
Simple scenario: Customer --- Transaction One customer could have one or more transactions, while one transaction could have one or more customers. They are connected via ...
