Forum Replies Created

Viewing 15 posts - 3,961 through 3,975 (of 7,484 total)

  • RE: Nanoseconds

    john.arnott (11/9/2012)

    Would method 1 be reliable even in the early morning hours? As SYSDATETIME() is non-deterministic, could it not use two slightly different values for the two calls?

    I get...

    November 9, 2012 at 1:16 pm

    #1557788

  • RE: COALESCE - 2

    It's a good question, with the right answer.

    I don't like the explanation, though. Admittedly those words occur in BoL, but I don't like them there either (although MS would...

    November 9, 2012 at 7:51 am

    #1557613

  • RE: Nanoseconds

    Lon-860191 (11/8/2012)

    Good question, but I would question if a method is reliable if it does not work less than 1/3 of the time daily, method 2 overloaded at 8 am...

    November 8, 2012 at 12:37 pm

    #1557333

  • RE: Nanoseconds

    Koen Verbeeck (11/8/2012)

    Nice question Tom, but I doubt if I'll ever use it 🙂

    (ps: you must be getting old if you can't count to four anymore :-P)

    I am indeed getting...

    November 8, 2012 at 5:22 am

    #1557128

  • RE: Nanoseconds

    matthew.flower (11/8/2012)

    While I haven't tried them (have work to do) I am not convinced that any of them "work reliably" when you consider changes to and from daylight savings. ...

    November 8, 2012 at 4:13 am

    #1557098

  • RE: Nanoseconds

    My apologies to all for the incompleteness of option 2. Although I agree with "Arturius" though that it is pretty obvious what is missing and don't think it should...

    November 8, 2012 at 4:07 am

    #1557089

  • RE: Halloween Protection

    craig 81366 (11/7/2012)

    Only one of us resorts to insults, name-calling and personal abuse to 'make his point'.

    So your

    craig 81366 (11/1/2012)

    I find your flippancy and stubbornness quite annoying. If you're...

    November 7, 2012 at 5:04 pm

    #1556974

  • RE: Enable Database Mail in 2012

    Nice easy one today.

    alex.d.garland (11/7/2012)

    I could be wrong but I don't think this is new to 2012 - I think the OP was just specifying a single known version for...

    November 7, 2012 at 5:44 am

    #1556726

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/6/2012)

    For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

    Anyone have any suggestions for me to...

    November 6, 2012 at 3:44 pm

    #1556596

  • RE: Statistics - 4

    Nice question. Anyone who has been keeping track of fixes for SQL 2008 R2 will find it easy, others may have to do some research.

    November 6, 2012 at 3:20 pm

    #1556592

  • RE: Halloween Protection

    craig 81366 (11/1/2012)

    L' Eomot Inversé (10/31/2012)

    craig 81366 (10/31/2012)

    Then why when I run the following by itself, does the plan not spool?

    SELECT AVG(COL) FROM TABLE_NAME

    Because a displayed MS SQL query plan...

    November 5, 2012 at 7:00 pm

    #1556268

  • RE: Halloween Protection

    craig 81366 (11/1/2012)

    All your transcript link provides is a recollection of the circumstances in which it was discovered.

    There are a number of unanswered possibilities:

    • When the problem was discovered, did the...

    November 5, 2012 at 5:30 pm

    #1556254

  • RE: Today's Random Word!

    opc.three (11/5/2012)

    ACTION ITEM

    INACTION ITEM

    November 5, 2012 at 9:09 am

    #1556102

  • RE: character ordering

    vk-kirov (11/2/2012)

    Incorrect. Try the following script and you'll get 62 characters:

    CREATE DATABASE qod_collation_db COLLATE Japanese_CI_AS_KS_WS;

    GO

    USE qod_collation_db;

    GO

    WITH Numbers AS

    ( SELECT 0 AS n

    UNION ALL

    SELECT...

    November 5, 2012 at 8:26 am

    #1556078

  • RE: SUM and Addition of Null

    Nice and easy question.

    Back to basics, really, but quite a few basics: aggregates, aggregates' handling of nulls, arithmetic operations handling of nulls, and implicit type conversion (as well as simple...

    November 5, 2012 at 7:07 am

    #1556038

    • Viewing 15 posts - 3,961 through 3,975 (of 7,484 total)