Mssql, Microsoft sql server, SSAS, SSRS ,SSIS , Analysis Service, Reporting Service, Integration Service, XMLA ,MDX ,SQL
วันอังคารที่ 10 กรกฎาคม พ.ศ. 2555
SQL Server list Database file name
select d.name as db_name, f.name as file_name, f.filename as logical_filename
from sysaltfiles f
inner join sysdatabases d
on (f.dbid = d.dbid)
order by 1,2
Restart OLAP Service from SSIS package
Reference from http://businessintelligencechronicles.blogspot.com/2009/02/using-ssis-script-task-to-executing.html
Using script task to connect remote server to stop & start mssqlserverOLAPService
Basicly we know command to stop and start olap service via command prompt.
Start -->Run command
Net stop mssqlserverOLAPService <---- Command to stop
Net start mssqlserverOLAPService <---- Command to start
In the example he remote to run Calc.exe via Command variable
In my case I create two string Command (Command1 , Command2)
Set Command1 = Net stop mssqlserverOLAPService
Set Command2 = Net start mssqlserverOLAPService
And then seperate commands into 2 script tasks
1 = Script for stop
2 = Script for start
**Remark If you SSIS version is 2008 You no need to change anythings except your command.
If you using SSIS 2005 you need to change a little bit command
from Dts.TaskResult = ScriptResults.Success to be Dts.TaskResult = Dts.result.Success
That's it.
That's work perfectly!!!
Thanks Christo Olivier
Using script task to connect remote server to stop & start mssqlserverOLAPService
Basicly we know command to stop and start olap service via command prompt.
Start -->Run command
Net stop mssqlserverOLAPService <---- Command to stop
Net start mssqlserverOLAPService <---- Command to start
In the example he remote to run Calc.exe via Command variable
In my case I create two string Command (Command1 , Command2)
Set Command1 = Net stop mssqlserverOLAPService
Set Command2 = Net start mssqlserverOLAPService
And then seperate commands into 2 script tasks
1 = Script for stop
2 = Script for start
**Remark If you SSIS version is 2008 You no need to change anythings except your command.
If you using SSIS 2005 you need to change a little bit command
from Dts.TaskResult = ScriptResults.Success to be Dts.TaskResult = Dts.result.Success
That's it.
That's work perfectly!!!
Thanks Christo Olivier
วันเสาร์ที่ 7 กรกฎาคม พ.ศ. 2555
Window server ,login exceed remote desktop
f using RDP 6 client or above:
mstsc /v ipOfServer /admin
If using older than RDP 6:
mstsc /v ipOfServer /console
Credit
http://serverfault.com/questions/43435/terminal-server-has-exceeded-max-number-of-allowed-connections
วันพุธที่ 4 กรกฎาคม พ.ศ. 2555
OLAP Distinct count measures
Analysis Services Distinct Count Optimization
Refer to :
http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/09/20/analysis-services-distinct-count-optimization-using-solid-state-devices.aspx
สมัครสมาชิก:
บทความ (Atom)