12,405,895 members (39,654 online)

# Welcome to the Lounge

For lazing about and discussing anything in a software developer's life that takes your fancy except 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.

 Re: Follow up on If you had 5 years to live SoMad10-Jan-14 8:44 SoMad 10-Jan-14 8:44
 Re: Follow up on If you had 5 years to live Mike Hankey10-Jan-14 9:08 Mike Hankey 10-Jan-14 9:08
 Re: Follow up on If you had 5 years to live SoMad10-Jan-14 9:12 SoMad 10-Jan-14 9:12
 Re: Follow up on If you had 5 years to live RyanDev10-Jan-14 8:56 RyanDev 10-Jan-14 8:56
 Re: Follow up on If you had 5 years to live Mike Hankey10-Jan-14 9:09 Mike Hankey 10-Jan-14 9:09
 How to deal with that Kurmudgen MacSpudster10-Jan-14 11:37 MacSpudster 10-Jan-14 11:37
 Re: How to deal with that Kurmudgen Mike Hankey10-Jan-14 13:23 Mike Hankey 10-Jan-14 13:23
 Mind...Blown IndifferentDisdain10-Jan-14 8:12 IndifferentDisdain 10-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.
 Re: Mind...Blown GuyThiebaut10-Jan-14 8:25 GuyThiebaut 10-Jan-14 8:25
 Re: Mind...Blown IndifferentDisdain10-Jan-14 8:27 IndifferentDisdain 10-Jan-14 8:27
 Re: Mind...Blown GuyThiebaut10-Jan-14 8:38 GuyThiebaut 10-Jan-14 8:38
 Re: Mind...Blown Pualee10-Jan-14 8:35 Pualee 10-Jan-14 8:35
 Re: Mind...Blown IndifferentDisdain10-Jan-14 8:52 IndifferentDisdain 10-Jan-14 8:52
 Re: Mind...Blown GuyThiebaut10-Jan-14 23:17 GuyThiebaut 10-Jan-14 23:17
 Re: Mind...Blown Richard Deeming10-Jan-14 8:35 Richard Deeming 10-Jan-14 8:35
 Re: Mind...Blown IndifferentDisdain10-Jan-14 8:53 IndifferentDisdain 10-Jan-14 8:53
 Re: Mind...Blown Ravi Bhavnani10-Jan-14 10:06 Ravi Bhavnani 10-Jan-14 10:06
 Re: Mind...Blown IndifferentDisdain10-Jan-14 10:08 IndifferentDisdain 10-Jan-14 10:08
 Re: Mind...Blown Ravi Bhavnani10-Jan-14 10:16 Ravi Bhavnani 10-Jan-14 10:16
 Re: Mind...Blown IndifferentDisdain10-Jan-14 10:21 IndifferentDisdain 10-Jan-14 10:21
 Re: Mind...Blown Ravi Bhavnani10-Jan-14 10:23 Ravi Bhavnani 10-Jan-14 10:23
 Re: Mind...Blown _Maxxx_10-Jan-14 14:46 _Maxxx_ 10-Jan-14 14:46
 Re: Mind...Blown _Damian S_12-Jan-14 12:10 _Damian S_ 12-Jan-14 12:10
 While listening to The Who Ferd Really10-Jan-14 6:48 Ferd Really 10-Jan-14 6:48
 Re: While listening to The Who DaveAuld10-Jan-14 7:19 DaveAuld 10-Jan-14 7:19
 Last Visit: 31-Dec-99 18:00     Last Update: 29-Jul-16 19:41 Refresh « Prev1...7463746474657466746774687469747074717472 Next »

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    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.160721.1 | Last Updated 30 Jul 2016