[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1246
  • Last Modified:

sid data type

what is the benefit for SQL Server to name SID in varbinary instead of varchar?

thanks
0
anushahanna
Asked:
anushahanna
  • 4
  • 2
2 Solutions
 
Mohit VijayCommented:
It helps to manage uniqueness id when you have unlimited number of user. Its something bigger then GUID.
0
 
Mohit VijayCommented:
Biggest benefit is:

When you are moving SQL Server logins from one server to another and you want the logins to have the same SID between servers
0
 
anushahannaAuthor Commented:
>>It helps to manage uniqueness id when you have unlimited number of user

varchar can take care of this, too, right? especially with 85 characters. (credit card is only 16 digits, and we trust it!)
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Mohit VijayCommented:
You are correct, but SID is more secure.
0
 
Mohit VijayCommented:
If you remember, initially table use int as key, after that bigint (autonumber), after that it increase the limit and become GUID etc.. similarly now for biggest database SID is secured and manageable. Isnt it?
0
 
anushahannaAuthor Commented:
OK. Thanks for that VjSoft. That makes sense, in terms of more bigger IDs.

Thanks again.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now