Forum Replies Created

Viewing 15 posts - 106 through 120 (of 148 total)

  • RE: Dating for DBAs - a second date

    Hi Duncan

    About a week ago, you asked just about the same question, with the same words (choices was different) and the language was part of the answer... I should...

  • RE: Length

    I agree with bitbucket: the question is for nVarchar, not nChar.

    What I don't understand, is why SQL told me that the lenght is 4, but microsoft says "the storage size,...

  • RE: Creating an Indexed View

    Hello vk-kirov

    vk-kirov (3/31/2011)


    Try this one ...

    Works fine!

    vk-kirov (3/31/2011)


    A unique clustered index may contain more than one column. You need a unique index on exactly one non-nullable column.

    I needed a...

  • RE: Creating an Indexed View

    When I tried to answer the QOD, the question had been changed for two part query and the answer "none of the above" was there .

    Because I know...

  • RE: Changing collations

    This one was a pretty hard one.

    I never heard of "Collate" and I was converting "Collate" with "collation" wich mean "small lunch" in french... but I don't think that...

  • RE: Scaled-down SQL

    UMG Developer (3/21/2011)


    Did you notice that the division increased the scale leaving you with three trailing zeros?

    If you look at the link in the explanation you will see that division...

  • RE: Scaled-down SQL

    michael.kaufmann (3/21/2011)


    tilew-948340 (3/20/2011)


    Why??? :crazy:

    If you use a precsion of 23, the math is as follows:

    - Precision: 47 - 38 = 9

    - Scale: 20 - 9 = 11

    - Result: DECIMAL(38,11)

    Ok!...

  • RE: Scaled-down SQL

    I am sorry, but I realy, realy don't understand why D is not good, even if I do your formula.

    Why is so that D would have a truncate answer...

  • RE: Data conversion

    Well, that was an interesting question, not for the question itself (I don't know SQL enough to have seen any thing that would have not making it worked, so I...

  • RE: data type precedence!

    I knew about that user-defined data types was the highest and I would have bet a lot that char was lower than binary...

    Well, that just proove that there...

  • RE: CONVERT function

    bitbucket-25253 (3/15/2011)


    As we all do ... let me challenge you .. submit a good QOD, you will be surprised at what you learn, quote]

    Submit a QOD, even a bad one,...

  • RE: CONVERT function

    bitbucket-25253 (3/14/2011)


    tilew-948340 Posted Today @ 8:51 PM

    I gues I just had to not take a chance and do not answer it, but for the futur, if at least we don't...

  • RE: CONVERT function

    This is a nice question, but I do not agree about loosing one point when I got 3 good answers on 4 and also when you have to know 2...

  • RE: Disk Partitions

    That was a tricky question: I don't use window "server" and I know very little about them (my databases are small enought to put on "regular" window"), so for me,...

  • RE: RAID 5

    If you want to get back faster on your feet after a disk failure, I would think that RAID 10 is the better choice,

    but you don't argue about RAID...

Viewing 15 posts - 106 through 120 (of 148 total)