Forum Replies Created

Viewing 15 posts - 616 through 630 (of 658 total)

  • RE: Query cost

    I recently optimised a query and tried exactly these two constructs. The query plan for both was identical.

    So the correct answer is either "they are equal", or (more likely I...

    January 27, 2010 at 2:23 am

    #1109170

  • RE: Question of the Day for 21 Dec 2009

    "Due to the Holiday Season, and Frosty being a part of the season, an easy question was in order. "

    It might be easy if you're American. Who's Frosty the Snowman?!?

    :unsure:

    December 22, 2009 at 4:21 am

    #1095321

  • RE: Temp Tables

    Steve Jones - Editor (12/17/2009)

    wow, you guys are really splitting hairs. A restart includes a shutdown and startup of the database instance. How could you argue it includes anything else?...

    December 18, 2009 at 2:27 am

    #1093917

  • RE: Temp Tables

    BOL says "a global temporary table is dropped at the completion of the last Transact-SQL statement that was actively referencing the table when the creating session ended".

    I took this to...

    December 17, 2009 at 10:00 am

    #1093587

  • RE: Fun with Decimals

    Correct answer, but the explanation is completely wrong!

    December 16, 2009 at 9:00 am

    #1093088

  • RE: INT and SMALLINT

    Easy for a VB6 programmer 🙂

    If one of the options had been 1 or -1 or even 32767 I might have got it wrong though!

    December 15, 2009 at 6:57 am

    #1092480

  • RE: SELECT @local_variable

    I guessed rigtht, but only because I knew it had to begin with 'Question' and there was only one answer that did that. If there'd been an option for 'Question...

    December 14, 2009 at 3:53 am

    #1091835

  • RE: Clustered Index Internals

    "Dropping a rebuilding a clustered index on a partition scheme will move disk to other drives."

    I have no idea what this means, and the answer doesn't seem to mention it.

    Can...

    December 9, 2009 at 2:19 am

    #1089687

  • RE: Fun with Scale and Precision

    sknox (12/4/2009)

    Steve Eckhart (12/4/2009)

    select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?

    and

    select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10, right?

    wrong,...

    December 8, 2009 at 9:35 am

    #1089338

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    You know, I haven't tried writing a QotD. Have you?

    Ah, that old chestnut.

    I've never been Prime Minister either, but I still get to say what I think...

    November 17, 2009 at 9:30 am

    #1080354

  • RE: T-SQL

    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 equivelent to each...

    November 17, 2009 at 9:10 am

    #1080333

  • RE: T-SQL

    bitbucket-25253 (11/17/2009)

    Lynn Pettis has explained in great detail the reason the times are the same, and as a matter of fact has explained the reasoning better than I could have....

    November 17, 2009 at 8:16 am

    #1080289

  • RE: T-SQL

    Lynn Pettis (11/17/2009)

    Everyone is looking at the values, yes, they are "different", but both represent the same time. One is local, the other UTC.

    If that is the reasoning then...

    November 17, 2009 at 6:53 am

    #1080206

  • RE: T-SQL

    Thought about answering True, because for me (in the UK) they will return the same value, but figured that the author was probably in the US so the answer was...

    November 17, 2009 at 2:53 am

    #1080115

  • RE: DateTime Trick

    Surely date formatting should normally be part of the presentation layer? I always return the whole datetime value and format it on the client, using their regional settings etc.

    October 27, 2009 at 4:08 am

    #1071096

Viewing 15 posts - 616 through 630 (of 658 total)