Posts tagged "2008"

SSAS: MDX Average Script On SSAS 2008

The MDX script on Microsoft Analysis Service (SSAS) 2008 and 2005 are different from SQL 2000. Here’s an example how to calculate average using MDX script on Analysis Service 2008. SSAS 2008, How to calculate Net Value By Date (NetValue / Date)

Old one, SSAS 2000, How to calculate Net Value By Date (NetValue… Continue reading

Shrink / Truncate Log File On SQL Server 2008

The common T-SQL script to shrink/truncate log file is using the script below

But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same log file size, nothing change (shrink) . In other word you cannot shrink the log file. To solve the issue here’s a work… Continue reading

RDC and SQL Server Management Studio 2008 on Vista x86, cannot connect to Windows Server 2008 x64

Problem 1. Remote Desktop Connection (RDC) from Vista x86 as Client to Windows Server 2008 x64 as Server, lost (disconnected) in randomize duration. The error message: Because of an error in data encryption, this session will end. Please try connecting to the remote computer again 2. SQL Server Management Studio 2008Β  on Vista x86Β  cannot… Continue reading