Solved

sid data type

Posted on 2010-08-26
6
1,130 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
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…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

820 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