Jul
28
comment Round Robin Assignments matching on Zip Codes
I think your first code block has a typo, you're selecting from employees, but ordering on CustomerId? More importantly, what happens when a customer has a ZIP that no employee has, or vice versa, so there's no obvious match? Or what happens if there are multiples, do they just get split up across all of them?
Jul
13
awarded Good Answer
Jul
7
comment Chain of events in second act of "Seveneves"
I agree that reading through this section was horribly frustrating, and I kept seeking an out. But I think that's part of what makes the story compelling. As I was discussing with my wife last night when she said "turn that awful noise off!" while I was listening to one of the most beautiful musical pieces ever written (King Crimson's "Red"), "NICE art and BEAUTIFUL art are two completely different things, and the former is rather boring".
Jul
7
answered Run Alter Database with Set READ_COMMITTED_SNAPSHOT to ON
Jun
12
answered Sql How to Join a table where data in Colums are alike
Jun
8
comment Is primary key always clustered?
@C-F - that's not a reason to cluster. If you're querying based on that primary key, the its index will get you there. And possibly quicker, too, since it almost certainly will require fewer IOs to get through a relative narrow index compared to the full width of the rows in the clustered index.
Jun
8
answered SQL function to get count of how many times string appears in column?
Apr
28
answered When can cropping off a part or including the whole subject's body be considered a distraction?
Feb
27
awarded Nice Question
Nov
3
awarded Yearling
Mar
13
awarded Famous Question
Nov
18
awarded Nice Answer
Oct
25
awarded Popular Question
Apr
20
awarded Yearling
Apr
20
awarded Yearling
Apr
17
awarded Notable Question
Nov
16
awarded Self-Learner
Nov
6
awarded Yearling
Nov
6
awarded Nice Answer
Apr
18
comment Use a shot list or not?
How specific are you in directing the model to these shots? Do you show them a sample, and say "try to be in this position"? Or is it more informal, allowing the model to add some personality on their own (so you'd say "I'd like a head shot at 1/4 profile, with some hair light; can you show me a that?")?
1 2 3 4 5