Forum Replies Created

Viewing 15 posts - 631 through 645 (of 819 total)

  • RE: STUFF Function

    Koen Verbeeck (5/16/2011)


    And the explanation doesn't mention why inserting NULL in another string doesn't result in NULL, but in an empty space instead.

    I am curious: bol does not mention the...

  • RE: Replication DR

    SQLRNNR (5/4/2011)


    I like it too. I also like that the R2 doc seems better written on this topic than the SQL 2008 doc

    I agree with you! 😀

  • RE: Normalization

    Great question. 😛

  • RE: Running SSMS after AD account is disabled

    In addition, the administrator should disable in AD and kill all disabled-user's connections.

  • RE: Service Broker Poison Messages

    Wonder question! 😀

  • RE: Money and Decimal Datatypes

    It's a good habit always to specify precision and scale because of changing default in future releases.

  • RE: Length

    Steve Jones - SSC Editor (4/12/2011)


    Everyone will get points back and I have corrected the question. Apologies for not fixing this earlier.

    You do not have to post to get points...

  • RE: Dating for DBAs - a second date

    Thank you very much for this beautiful qotd.

    It's unbelievable, but true, only new types DATE and DATETIME2 work in any case.

  • RE: Length

    Only one comment: I want back my points! :-D:-D:-D

  • RE: Creating an Indexed View

    The correct answer is "None of the above"

    http://msdn.microsoft.com/en-us/library/ms188783.aspx

    Tables must be referenced by two-part names, schema.tablename, in the view definition.

    I want back my points.

  • RE: Changing collations

    In these days, I am changing collate on third party's database.

  • RE: Scaled-down SQL

    Unbelievable, but true!

    Thank you for qotd and a clear explanation!

  • RE: Data conversion

    tommyh (3/18/2011)


    I was hoping that SQL would fail on the last comma in the create table part. But SQL was just as happy to create a table like that.

    /T

    I...

  • RE: Table Design

    Thank you for qotd. I really learnt something new and useful.

    I should read it 10 times carefully, but at last, when I understand that the goal of qotd was to...

  • RE: RAID 10

    Koen Verbeeck (3/3/2011)


    Dammit, I got it wrong because of this misleading quote in Wikipedia:

    RAID 1+0: mirrored sets in a striped set (minimum two disks but more commonly four disks to...

Viewing 15 posts - 631 through 645 (of 819 total)