Viewing 15 posts - 31 through 45 (of 65 total)
And in real life, outside of the academia you probably live in, my method of handling questions like this resulted in 6 out of 6 interviews last Fall resulting in...
February 9, 2011 at 7:23 pm
The algorithm which computer science students should be learning (to get the max of a set) is one of
MaxOfSet S U {x} = Reduce lambda x y : [ x...
February 9, 2011 at 7:05 pm
Are you the same person as nzngh who asked the original question that started this topic? If not, how do you claim to know what the precise...
February 8, 2011 at 6:08 pm
I guess it's perception then, having been through many interviews. A question like this is usually loaded.
I didn't find the question loaded, an attempt by the interviewer to show...
February 8, 2011 at 5:38 pm
Not entirely sure why you're up in arms over this one, nadabadan. It might just be the way I'm reading your writing style. Either way:
The only reason I'm...
February 8, 2011 at 4:08 pm
Craig Farrell (2/8/2011)
nadabadan (2/8/2011)
February 8, 2011 at 3:28 pm
GSquared (2/8/2011)
nadabadan (2/8/2011)
GSquared (2/7/2011)
nzngh (2/6/2011)
February 8, 2011 at 3:23 pm
Craig Farrell (2/8/2011)
nadabadan (2/8/2011)
February 8, 2011 at 3:04 pm
If you need to sync the data once a day or at some interval, then look into snapshot replication. If you need the data updated throughout the day, look into...
February 8, 2011 at 2:13 pm
GSquared (2/7/2011)
nzngh (2/6/2011)
February 8, 2011 at 1:56 pm
mike 57299 (1/30/2011)
So ColdCoffee's solution would get me one record per name with up to 3 colors listed in 3 columns?
No, it would get you close to what you originally...
January 31, 2011 at 5:24 pm
Perry Whittle (1/31/2011)
nadabadan (1/31/2011)
If the data is constantly changing as the OP stated, using snapshots on mirrored dbs would not be a good idea.
the OP doesn't actually state that anywhere,...
January 31, 2011 at 5:21 pm
TheSQLGuru (1/31/2011)
I think Perry has the best recommendation here - snapshots on the mirrored databases.
If the data is constantly changing as the OP stated, using snapshots on mirrored dbs would...
January 31, 2011 at 11:05 am
mike 57299 (1/30/2011)
Yes, there is an identity column.
You can modify ColdCoffee's query to order by the id column. For example if the identity column is name [id], you can replace...
January 30, 2011 at 9:02 pm
Is that level of denied permission normal at all big corps cuz i could of had this done 2 days ago?
What is your position and what do you do? I...
January 30, 2011 at 5:33 pm
Viewing 15 posts - 31 through 45 (of 65 total)