Forum Replies Created

Viewing 15 posts - 181 through 195 (of 205 total)

  • RE: How can we standardize SQL Server Data Deployments?

    Adam Gojdas (12/16/2009)

    I never really cared for this method using a drop. When one has any auditing of the DDL that takes place this always has the extra drop...

    December 17, 2009 at 6:18 am

    #1093454

  • RE: SQL Server Jobs

    david.wright-948385 (11/30/2009)

    kevin.l.williams (11/27/2009)

    I don't think I learned anything useful by getting this question wrong. Who cares if you can create a job in express if it can't be used?

    It wouldn't...

    November 30, 2009 at 3:00 am

    #1085302

  • RE: SQL Server Jobs

    kevin.l.williams (11/27/2009)

    I don't think I learned anything useful by getting this question wrong. Who cares if you can create a job in express if it can't be used?

    It wouldn't be...

    November 30, 2009 at 2:57 am

    #1085300

  • RE: SQL Server Jobs

    I think this is one for Steve (Jones):

    There have been a number of QoDs lately that appear to be designed deliberately to mislead, on the pretext that everyone will...

    November 27, 2009 at 5:54 am

    #1084878

  • RE: ^ : T-SQL

    I'm pretty sure the '^' character is a caret, not a carot 🙂

    November 23, 2009 at 4:14 am

    #1082877

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    david.wright-948385 (11/17/2009)

    Just wondering... did you write the QOD Lynn?

    Nope, but I got the answer right without reading the discussion or running the code. I guess the force...

    November 18, 2009 at 3:23 am

    #1080771

  • RE: T-SQL

    Just wondering... did you write the QOD Lynn?

    November 17, 2009 at 12:54 pm

    #1080489

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    I don't expect getdate() and gtutcdate() to return the same time. They return the same equivalent time. Again, 8:00 AM MST == 3:00 PM UTC.

    Exactly. So...

    November 17, 2009 at 11:42 am

    #1080430

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    Dietmar Weickert (11/17/2009)

    ... finally trying to argue that the whole thing were for educational purposes is even more cynical. I hope nobody ever had or will have a...

    November 17, 2009 at 11:17 am

    #1080415

  • RE: T-SQL

    Can the QOD be changed then please? If not to change the answer (which is my preference) then to explain why the answer given is as it is.

    November 17, 2009 at 9:34 am

    #1080359

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    Toreador (11/17/2009)

    Lynn Pettis (11/17/2009)

    Yes, getdate() and getutcdate() return different values, just look at what they return when you run them. However both functions return values that are...

    November 17, 2009 at 9:32 am

    #1080357

  • RE: T-SQL

    Here is Steve Jones article about the QOD

    http://www.sqlservercentral.com/articles/SQLServerCentral/62764/

    And quoting from the article here is the objective of the QOD

    The Question of the Day is just what it's titled: a daily...

    November 17, 2009 at 8:23 am

    #1080292

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    david.wright-948385 (11/17/2009)

    I think getdate() = getutcdate() would return false in your time zone, so I think they're probably different!

    Everyone is looking at the values, yes, they are "different",...

    November 17, 2009 at 7:38 am

    #1080249

  • RE: T-SQL

    I think getdate() = getutcdate() would return false in your time zone, so I think they're probably different!

    November 17, 2009 at 6:23 am

    #1080180

  • RE: T-SQL

    A good example of the need for thorough testing 🙂 Would rather not have a mark against me on the stats for answering correctly though 🙁

    November 17, 2009 at 5:31 am

    #1080167

Viewing 15 posts - 181 through 195 (of 205 total)