EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB37741: In MicroStrategy 9.2.0 and newer, Object GUID's are stored as the UNIQUEIDENTIFIER data type when the Metadata is hosted on Microsoft SQL Server.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article discusses a change in the way MicroStrategy stores object IDs when using Microsoft SQL Server as the metadata database.

Starting from Strategy 9.2.0, Object GUID's are stored as the UNIQUEIDENTIFIER data type if the metadata is hosted on Microsoft SQL Server. For example, before Strategy 9.2.0, the OBJECT_ID of the Administrator user account in the DSSMDOBJINFO table is stored as CHAR(32):


54F3D26011D2896560009A8E67019608

 
In Strategy 9.2.0 or newer, the OBJECT_ID is stored as:

54F3D260-8965-11D2-8E9A-006008960167

 
The switch is made in compliance with the most commonly used structure of the GUID. See http://en.wikipedia.org/wiki/Globally_unique_identifier. In addition, storing an object's GUID as UNIQUEIDENTIFIER significantly reduces metadata size (~40%) and improves performance (up to 25% in certain search scenarios). 


Comment

0 comments

Details

Knowledge Article

Published:

May 23, 2017

Last Updated:

May 23, 2017