# Welcome to the Lounge

For lazing about and discussing anything in a software developer's life that takes your fancy.
The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct and please don't post ads.

 Re: Customers _Damian S_ 12-Jan-14 13:08
 Re: Customers charlieg 13-Jan-14 4:04
 Follow up on If you had 5 years to live Mike Hankey 10-Jan-14 9:26
 Re: Follow up on If you had 5 years to live Richard Deeming 10-Jan-14 9:37
 Re: Follow up on If you had 5 years to live Mike Hankey 10-Jan-14 9:42
 Re: Follow up on If you had 5 years to live Mike Hankey 10-Jan-14 10:08
 Re: Follow up on If you had 5 years to live RyanDev 10-Jan-14 9:56
 Re: Follow up on If you had 5 years to live Mike Hankey 10-Jan-14 10:09
 How to deal with that Kurmudgen [modified] MacSpudster 10-Jan-14 12:37
 Re: How to deal with that Kurmudgen Mike Hankey 10-Jan-14 14:23
 Mind...Blown [modified] IndifferentDisdain 10-Jan-14 9:12
 For the life of me, I can't explain this. This isn't intended to be a programming question, more a "nope, don't believe it, even if I'm seeing it" thing.   We host our main app's data in SQL Azure, and we have information in a given table w/ part of the primary key as a datetime (has month-end mutual fund data). One particular function seemed to be taking too long, so we started investigating this afternoon.   If I run a given statement w/ asofdate = '11/30/2013, query takes 20 seconds. Seems slow.   If I run the same statement, changing only asofdate = '10/31/2013', query takes 0.1 seconds. Odd. No significant # of diff recs between those two dates (26,488 for Nov vs. 26,382 for Oct).   So now I'm thinking it's either the way those 11/30 recs were physically stored, or something special about that particular date, until...   If I run the same statement w/ asofdate >= '11/30/2013' (most recent date in db right now), it again takes 0.1 seconds.   Cannot replicate anything close to this in our on-site SQL Server dev dbs.   How the elephant can asofdate >= '11/30/2013' ever be faster than = '11/30/2013'?modified 10-Jan-14 16:07pm.
 Re: Mind...Blown GuyThiebaut 10-Jan-14 9:25
 Re: Mind...Blown IndifferentDisdain 10-Jan-14 9:27
 Re: Mind...Blown GuyThiebaut 10-Jan-14 9:38
 Re: Mind...Blown Pualee 10-Jan-14 9:35
 Re: Mind...Blown IndifferentDisdain 10-Jan-14 9:52
 Re: Mind...Blown GuyThiebaut 11-Jan-14 0:17
 Re: Mind...Blown Richard Deeming 10-Jan-14 9:35
 Re: Mind...Blown IndifferentDisdain 10-Jan-14 9:53
 Re: Mind...Blown Ravi Bhavnani 10-Jan-14 11:06
 Re: Mind...Blown IndifferentDisdain 10-Jan-14 11:08
 Re: Mind...Blown Ravi Bhavnani 10-Jan-14 11:16
 Re: Mind...Blown IndifferentDisdain 10-Jan-14 11:21
 Re: Mind...Blown Ravi Bhavnani 10-Jan-14 11:23
 Re: Mind...Blown _Maxxx_ 10-Jan-14 15:46
 Re: Mind...Blown _Damian S_ 12-Jan-14 13:10
 While listening to The Who Ferd Really 10-Jan-14 7:48
 Re: While listening to The Who DaveAuld 10-Jan-14 8:19
 ...The Eagles Motel Kamzoil 10-Jan-14 9:18
 Re: While listening to The Who OriginalGriff 10-Jan-14 9:20
 Pink Floyd Mike Hankey 10-Jan-14 9:23
 Re: While listening to The Who _Maxxx_ 10-Jan-14 15:48
 London Underground map. Septimus Hedgehog 10-Jan-14 6:12
 Rule of thumb and config files RugbyLeague 10-Jan-14 6:09
 Re: Rule of thumb and config files Manfred R. Bihy 10-Jan-14 6:24
 Re: Rule of thumb and config files RugbyLeague 10-Jan-14 6:29
 Re: Rule of thumb and config files Manfred R. Bihy 10-Jan-14 6:37
 Re: Rule of thumb and config files RugbyLeague 10-Jan-14 6:39
 Re: Rule of thumb and config files Sentenryu 10-Jan-14 8:33
 Re: Rule of thumb and config files RugbyLeague 14-Jan-14 0:56
 Re: Rule of thumb and config files Eddy Vluggen 10-Jan-14 7:33
 Re: Rule of thumb and config files PIEBALDconsult 10-Jan-14 9:26
 Re: Rule of thumb and config files PIEBALDconsult 10-Jan-14 9:25
 APOD mark merrens 10-Jan-14 6:07
 Re: APOD Manfred R. Bihy 10-Jan-14 6:30
 Re: APOD glennPattonWork 10-Jan-14 7:17
 Re: APOD Mike Hankey 10-Jan-14 7:54
 Last Visit: 31-Dec-99 19:00     Last Update: 27-Dec-14 1:32 Refresh « Prev1...1529153015311532153315341535153615371538 Next »