Click here to Skip to main content
13,000,469 members (59,183 online)

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

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, no programming questions and please don't post ads.
 
GeneralRe: Customers Pin
_Damian S_12-Jan-14 12:08
professional_Damian S_12-Jan-14 12:08 
GeneralRe: Customers Pin
charlieg13-Jan-14 3:04
membercharlieg13-Jan-14 3:04 
GeneralFollow up on If you had 5 years to live Pin
Mike Hankey10-Jan-14 8:26
memberMike Hankey10-Jan-14 8:26 
GeneralRe: Follow up on If you had 5 years to live Pin
Richard Deeming10-Jan-14 8:37
professionalRichard Deeming10-Jan-14 8:37 
GeneralRe: Follow up on If you had 5 years to live Pin
Mike Hankey10-Jan-14 8:42
memberMike Hankey10-Jan-14 8:42 
GeneralRe: Follow up on If you had 5 years to live Pin
SoMad10-Jan-14 8:46
professionalSoMad10-Jan-14 8:46 
GeneralRe: Follow up on If you had 5 years to live Pin
SoMad10-Jan-14 8:44
professionalSoMad10-Jan-14 8:44 
GeneralRe: Follow up on If you had 5 years to live Pin
Mike Hankey10-Jan-14 9:08
memberMike Hankey10-Jan-14 9:08 
GeneralRe: Follow up on If you had 5 years to live Pin
SoMad10-Jan-14 9:12
professionalSoMad10-Jan-14 9:12 
JokeRe: Follow up on If you had 5 years to live Pin
RyanDev10-Jan-14 8:56
mvpRyanDev10-Jan-14 8:56 
GeneralRe: Follow up on If you had 5 years to live Pin
Mike Hankey10-Jan-14 9:09
memberMike Hankey10-Jan-14 9:09 
GeneralHow to deal with that Kurmudgen Pin
MacSpudster10-Jan-14 11:37
memberMacSpudster10-Jan-14 11:37 
GeneralRe: How to deal with that Kurmudgen Pin
Mike Hankey10-Jan-14 13:23
memberMike Hankey10-Jan-14 13:23 
GeneralMind...Blown Pin
IndifferentDisdain10-Jan-14 8:12
memberIndifferentDisdain10-Jan-14 8: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.

GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 8:25
memberGuyThiebaut10-Jan-14 8:25 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:27
memberIndifferentDisdain10-Jan-14 8:27 
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 8:38
memberGuyThiebaut10-Jan-14 8:38 
GeneralRe: Mind...Blown Pin
Pualee10-Jan-14 8:35
memberPualee10-Jan-14 8:35 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:52
memberIndifferentDisdain10-Jan-14 8:52 
GeneralRe: Mind...Blown Pin
GuyThiebaut10-Jan-14 23:17
memberGuyThiebaut10-Jan-14 23:17 
JokeRe: Mind...Blown Pin
Richard Deeming10-Jan-14 8:35
professionalRichard Deeming10-Jan-14 8:35 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 8:53
memberIndifferentDisdain10-Jan-14 8:53 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:06
professionalRavi Bhavnani10-Jan-14 10:06 
GeneralRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 10:08
memberIndifferentDisdain10-Jan-14 10:08 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:16
professionalRavi Bhavnani10-Jan-14 10:16 
AnswerRe: Mind...Blown Pin
IndifferentDisdain10-Jan-14 10:21
memberIndifferentDisdain10-Jan-14 10:21 
GeneralRe: Mind...Blown Pin
Ravi Bhavnani10-Jan-14 10:23
professionalRavi Bhavnani10-Jan-14 10:23 
GeneralRe: Mind...Blown Pin
_Maxxx_10-Jan-14 14:46
professional_Maxxx_10-Jan-14 14:46 
GeneralRe: Mind...Blown Pin
_Damian S_12-Jan-14 12:10
professional_Damian S_12-Jan-14 12:10 
GeneralWhile listening to The Who Pin
Ferd Really10-Jan-14 6:48
memberFerd Really10-Jan-14 6:48 
GeneralRe: While listening to The Who Pin
DaveAuld10-Jan-14 7:19
protectorDaveAuld10-Jan-14 7:19 
General...The Eagles Pin
Motel Kamzoil10-Jan-14 8:18
memberMotel Kamzoil10-Jan-14 8:18 
GeneralRe: While listening to The Who Pin
OriginalGriff10-Jan-14 8:20
protectorOriginalGriff10-Jan-14 8:20 
GeneralPink Floyd Pin
Mike Hankey10-Jan-14 8:23
memberMike Hankey10-Jan-14 8:23 
GeneralRe: While listening to The Who Pin
_Maxxx_10-Jan-14 14:48
professional_Maxxx_10-Jan-14 14:48 
GeneralLondon Underground map. Pin
Septimus Hedgehog10-Jan-14 5:12
memberSeptimus Hedgehog10-Jan-14 5:12 
GeneralRule of thumb and config files Pin
RugbyLeague10-Jan-14 5:09
memberRugbyLeague10-Jan-14 5:09 
GeneralRe: Rule of thumb and config files Pin
Manfred R. Bihy10-Jan-14 5:24
professionalManfred R. Bihy10-Jan-14 5:24 
GeneralRe: Rule of thumb and config files Pin
RugbyLeague10-Jan-14 5:29
memberRugbyLeague10-Jan-14 5:29 
GeneralRe: Rule of thumb and config files Pin
Manfred R. Bihy10-Jan-14 5:37
professionalManfred R. Bihy10-Jan-14 5:37 
GeneralRe: Rule of thumb and config files Pin
RugbyLeague10-Jan-14 5:39
memberRugbyLeague10-Jan-14 5:39 
GeneralRe: Rule of thumb and config files Pin
Sentenryu10-Jan-14 7:33
memberSentenryu10-Jan-14 7:33 
GeneralRe: Rule of thumb and config files Pin
RugbyLeague13-Jan-14 23:56
memberRugbyLeague13-Jan-14 23:56 
GeneralRe: Rule of thumb and config files Pin
Eddy Vluggen10-Jan-14 6:33
memberEddy Vluggen10-Jan-14 6:33 
GeneralRe: Rule of thumb and config files Pin
PIEBALDconsult10-Jan-14 8:26
professionalPIEBALDconsult10-Jan-14 8:26 
GeneralRe: Rule of thumb and config files Pin
PIEBALDconsult10-Jan-14 8:25
professionalPIEBALDconsult10-Jan-14 8:25 
GeneralAPOD Pin
mark merrens10-Jan-14 5:07
membermark merrens10-Jan-14 5:07 
GeneralRe: APOD Pin
Manfred R. Bihy10-Jan-14 5:30
professionalManfred R. Bihy10-Jan-14 5:30 
GeneralRe: APOD Pin
glennPattonWork10-Jan-14 6:17
professionalglennPattonWork10-Jan-14 6:17 
GeneralRe: APOD Pin
Mike Hankey10-Jan-14 6:54
memberMike Hankey10-Jan-14 6:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170624.1 | Last Updated 25 Jun 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid