By Kevin Jobe on Sunday, June 13, 2010 12:48 PM

Open Management Studio and run the following query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
If SQL 2008 R2 is installed, the following results should be returned:
10.50.1600.1     RTM     Enterprise Edition (64-bit)

 

The following would indicate SQL Server 2008, with SP1;
10.0.2740.0   SP1     Enterprise Edition (64-bit)

By Kevin Jobe on Thursday, July 31, 2008 8:30 PM

Have you ever been attempting to deploy a cube on a new server only to get the following message?

The trust relationship between the primary domain and the trusted domain failed

It's possible you had created roles in your SSAS cube, which reference another domain.  These roles will need to be removed (or at least the members of the roles from the domain).  Also, here is a link where I learned of the fix: 

http://forums.microsoft.com/MSDN/ShowPost.aspx?P ... Read More »

Comments (0)

By Kevin Jobe on Wednesday, March 12, 2008 10:58 AM

Another friend in SQL is the CAST function.  Assume you need to join 2 tables on columns that have different data types, and the types are not compatible.  Use the CAST function in your join statement:

SELECT     EADP_AppDB.dbo.D_Resource.MemberId AS ResourceMemberID, dbo.vEADP_VistaReadyTransposed.ResourceID,
                      dbo.vEADP_VistaReadyTransposed.KPIName, dbo.vEADP_VistaReadyTransposed.KPI, dbo.vEADP_VistaReadyTransposed.KPIMemberID

FROM         EADP_AppDB.dbo.D_Resource INNER JOIN
              ... Read More »

By Kevin Jobe on Saturday, March 08, 2008 7:17 PM

 Often, you will need to transpose columns to rows in order to deliver data to the staging db or fact table.  When this need arises, the UNION ALL operator in SQL is your friend.

The following statement will accomplish this for you: (Table examples can be found by clicking the "more" link below)

SELECT     ResourceID, 'OSStatus' AS KPIName, OSStatus AS KPIValue
FROM         dbo.ViewOrTable
UNION ALL
SELECT     ResourceID, 'CPUStatus' AS KPIName, CpuStatus
FROM         dbo.ViewOrTable AS ViewOrTable_1
UNION ALL
SELECT     ResourceID, 'ProcessorStatus' AS KPIName, ProcessorStatus
FROM&# ... Read More »