Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Guid data type
Message
From
18/09/2020 12:19:51
 
 
To
15/09/2020 10:00:04
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01676133
Message ID:
01676161
Views:
58
Hi Christian, guids is the most accepted datatype because of the easy to use and knowledge, but some huge databases note that this cause fragmentation, more storage and will generate memory pressures. For a normal application the guids is the best option. I don't have experience implementing different cases but Take a look into this article of someone that needed to change the guids for a new option:
https://www.sqlservercentral.com/articles/an-alternative-to-guids

>Hi, I am wondering if there is a very good reason to use guid data type over nvarchar(36)? Usually I am trying to avoid special data types in case the database needs to be ported to mysql or postgres, and so far I never had problems using the guids in nvarchar(36) or character(36).
Perhaps someone has some experience with this and can give some ideas?
John Harold Belalcázar Lozano
Associate Director Of Development
http://www.belvicto.co/
jhbelalc@gmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform