Reputation
529
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 13
Newest
 Curious
Impact
~40k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Jan
18
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
I can't say I completely follow the explanation about byte ordering, but it is making me think about indexing. Would uniqueidentifier be more or less likely to result in index fragmentation than binary?
Jan
18
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
I would assume the GUIDs are generated in the application, as I don't see them in the database.
Jan
18
awarded  Curious
Jan
17
awarded  Nice Question
Jan
17
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Yes, thankfully I don't have to deal with implicit casts as well.
Jan
17
accepted Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Jan
17
comment Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Yes, it was migrated from I think MySQL. And yes, there are lots of... interesting things to look at.
Jan
17
asked Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?
Jan
15
comment Perform admin tasks (e.g. create database, add diagram support) in SQL Server when not connected to domain
That doesn't work any more. I don't know if it is a change in SSMS or Windows, but it is most frustrating.
Oct
5
awarded  Notable Question
Jul
6
awarded  Custodian
Jul
6
reviewed Approve Unexpected SELECT permissions
Jul
6
answered Unexpected SELECT permissions
Jul
6
asked Unexpected SELECT permissions
May
10
awarded  Yearling
Feb
17
awarded  Popular Question
Dec
6
awarded  Popular Question
Sep
30
awarded  Notable Question
Apr
27
comment Are cross-database queries expensive in SQL Server?
I would like to know the cost in comparison to a query in the same table.
Apr
26
awarded  Critic