Solved

sid data type

Posted on 2010-08-26
6
1,095 Views
Last Modified: 2012-05-10
what is the benefit for SQL Server to name SID in varbinary instead of varchar?

thanks
0
Comment
Question by:anushahanna
  • 4
  • 2
6 Comments
 
LVL 8

Accepted Solution

by:
Mohit Vijay earned 500 total points
ID: 33534722
It helps to manage uniqueness id when you have unlimited number of user. Its something bigger then GUID.
0
 
LVL 8

Expert Comment

by:Mohit Vijay
ID: 33534748
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33535011
>>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
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 8

Expert Comment

by:Mohit Vijay
ID: 33535028
You are correct, but SID is more secure.
0
 
LVL 8

Assisted Solution

by:Mohit Vijay
Mohit Vijay earned 500 total points
ID: 33535041
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33535075
OK. Thanks for that VjSoft. That makes sense, in terms of more bigger IDs.

Thanks again.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to base a filter depending on fields contents? 15 50
SQL VIEW 7 24
SQL Server 2012 r2 - Sum causes too much time 5 15
Error is query 14 0
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now