andyb

less info
stack exchange network profile network profile
37 reputation
4
bio website
location Peterborough, United Kingdom
age 44
visits member for 1 year, 11 months
seen Apr 23 at 12:21
stats profile views 3

16 Actions

suggestions reviews revisions comments badges posts accepts all
Nov
16
 awarded  Editor
Nov
16
 comment Selecting values that are not associated with one side of a many to many relationship
Thanks. Fixed it.
Nov
16
 revised Selecting values that are not associated with one side of a many to many relationship
Fixed typo
Nov
16
 accepted Selecting values that are not associated with one side of a many to many relationship
Nov
16
 comment Selecting values that are not associated with one side of a many to many relationship
Fantastic. Thank you very much.
Nov
16
 asked Selecting values that are not associated with one side of a many to many relationship
Jun
27
 awarded  Supporter
Jun
27
 accepted What does CREATE ASSEMBLY do with the registered dll?
Jun
27
 comment What does CREATE ASSEMBLY do with the registered dll?
Thanks for the tip.
Jun
27
 comment What does CREATE ASSEMBLY do with the registered dll?
Thanks very much. That makes a lot of sense. I scripted the assembly and did see a long binary value like this: CREATE ASSEMBLY [AlphaShapes] AUTHORIZATION [dbo] FROM 0x4D5A900003000000 ... WITH PERMISSION_SET = SAFE It was about 19000 characters long, which sounds roughly right for a 10K dll.
Jun
27
 asked What does CREATE ASSEMBLY do with the registered dll?
Jan
26
 accepted Why use custom CLR aggregate functions for string concatenation and geometry unions in SQL Server?
Jan
26
 awarded  Scholar
Jan
26
 comment Why use custom CLR aggregate functions for string concatenation and geometry unions in SQL Server?
I guess the efficiency argument applies to geometry too, since you could use a SqlGeometryBuilder in .NET. Still surprised (wrt geometry) it's never even suggested as a quick and dirty option though. Thank you.
Jan
26
 awarded  Student
Jan
26
 asked Why use custom CLR aggregate functions for string concatenation and geometry unions in SQL Server?