Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (11/9/2010)

    In case anyone (living under a rock maybe) missed the announcement:

    Microsoft® SQL Server® code-named 'Denali' - Community Technology Preview 1 (CTP1) : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9

    Got a blog post with a couple...

    November 9, 2010 at 1:52 pm

    #1248573

  • RE: Daylight Savings Time

    david.beav (11/9/2010)

    The log values only go to seconds, no mS

    That's a shame. I'm wondering if it actually started off at 1:59:59:9998 or something, but reported it as 2:00:00.

    November 9, 2010 at 12:01 pm

    #1248490

  • RE: Daylight Savings Time

    david.beav (11/8/2010)

    Following up on my post, in case the details are interesting to anyone:

    - Googling says that Windows is supposed to change from 1:59:59.999 to 1:00:00 on the DST switch;...

    November 9, 2010 at 11:25 am

    #1248469

  • RE: Daylight Savings Time

    It seems impractical to simply not run jobs between 1AM and 3AM Sunday mornings, but that would take care of both Fall Back and Spring Forward.

    November 9, 2010 at 11:17 am

    #1248466

  • RE: Table Value Function

    mbender (11/3/2010)

    What does indexing do? None of our tables are indexed. By doing the Create Index, what will that do?

    Indexing helps improve the performance of queries on your tables....

    November 3, 2010 at 9:00 am

    #1246066

  • RE: Table Value Function

    mbender (11/3/2010)

    this is really cool code, would never have thought to do this. The one thing i'm missing is what happens if there is values in the previous month...

    November 3, 2010 at 8:57 am

    #1246059

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/3/2010)

    GilaMonster (11/3/2010)

    Gianluca Sartori (11/3/2010)

    I'm not suggesting anyone to cheat, but the voting system relies on browser cookies to determine if a vote was placed... :Whistling:

    and I have 2...

    November 3, 2010 at 7:53 am

    #1245999

  • RE: Daylight Savings Time

    Craig Farrell (11/2/2010)

    I must say I'm suddenly quite happy to be living in AZ. We don't mess with that old farmer's wit of a time system. Savings time......

    November 2, 2010 at 3:40 pm

    #1245788

  • RE: Daylight Savings Time

    Jon.Morisi (11/2/2010)

    I'm thinking I should just setup all my servers to use GMT no DST from now on...that's not way to not have to deal w/ any of it 🙂

    Sure,...

    November 2, 2010 at 1:53 pm

    #1245711

  • RE: Daylight Savings Time

    Alvin Ramard (11/2/2010)

    You could have a procedure that runs on start-up and runs in a loop checking the execution of the jobs. I wouldn't recommend it, but it's an...

    November 2, 2010 at 12:16 pm

    #1245624

  • RE: Daylight Savings Time

    Alvin Ramard (11/2/2010)

    Stefan Krzywicki (11/2/2010)

    WayneS (11/2/2010)

    george sibbald (11/2/2010)

    I'd agree with tom here, I've never noticed a problem, clocks going back or forward, other than negative run times recorded in...

    November 2, 2010 at 11:58 am

    #1245614

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/2/2010)

    Craig Farrell (11/2/2010)

    Brandie Tarvin (11/2/2010)

    GilaMonster (11/2/2010)

    WayneS (11/2/2010)

    Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?

    8000 characters for a date?...

    November 2, 2010 at 11:56 am

    #1245608

  • RE: Daylight Savings Time

    WayneS (11/2/2010)

    george sibbald (11/2/2010)

    I'd agree with tom here, I've never noticed a problem, clocks going back or forward, other than negative run times recorded in SQL2000. The doco I...

    November 2, 2010 at 11:39 am

    #1245590

  • RE: Daylight Savings Time

    george sibbald (11/2/2010)

    I'd agree with tom here, I've never noticed a problem, clocks going back or forward, other than negative run times recorded in SQL2000. The doco I enclosed...

    November 2, 2010 at 9:58 am

    #1245513

  • RE: Daylight Savings Time

    HowardW (11/2/2010)

    It should be worse the other way round to be honest. When you move into Daylight Saving Time, there is no 01:00 to 01:59, so I would assume that...

    November 2, 2010 at 9:02 am

    #1245464

Viewing 15 posts - 2,356 through 2,370 (of 2,838 total)