Forum Replies Created

Viewing 15 posts - 556 through 570 (of 819 total)

  • RE: NULLIF 1

    Koen Verbeeck (6/25/2012)


    Small error: the select statement selects 4 columns, the answers have only 3.

    BIG ERROR: I answered thinking at the first 3 columns, so that Y would return without...

  • RE: Database size in SQL Server 2012

    tommyh (6/19/2012)


    If one wants be really picky "Depends on File System" is actually the right answer.

    You can install 2012 on FAT32

    /T

    Is FAT32 still alive?

    FAT32 is deprecated because of...

  • RE: Index defaults 1

    Great question.

    Hugo, you are the number ONE!

    Thanks.

    😀

  • RE: Transaction isolation

    Good question!

  • RE: Sequences I

    Koen Verbeeck (4/17/2012)


    Carlo Romagnano (4/17/2012)


    I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.

    They will all be...

  • RE: Sequences I

    I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.

  • RE: Bulk Logged recovery model

    Nakul Vachhrajani (4/15/2012)


    The way I interpreted the question was:

    1. Database is in full-recovery mode

    2. User foresees bulk-operations (i.e. to be performed sometime in the future)

    3. User therefore changes the database...

  • RE: VIEWS 6

    I do not like this kind of EXTREMELY easy questions.

    😀

  • RE: Foreign key

    Another tricky and bad worded question.

    In the earlier versions of any DBMS, the foreign key was implemented thru triggers.

    So the answer should be "YES, implemented by trigger."

    Or change the question:...

  • RE: DateTime Functions

    Good question!

    Thanks.

    😛

  • RE: Finding the queries that use the most IO

    I tried on my production server:

    I got interesting results

    ordering by [Total IO] instead of [Average IO].

    Thanks!

  • RE: NOT BETWEEN

    cengland0 (3/30/2012)


    This one was so easy that I was looking for the "trick." I kept look and looking but never found one so I finally submitted my answer. ...

  • RE: Contained Databases

    New features are welcome!

    But, I get it wrong!

    😛

  • RE: VIEWS 4

    Easy question!

    Good practice is never use "SELECT * FROM" in view, too.

    😉

  • RE: SOME

    Is there difference between SOME and ANY?

    Can someone explain?

Viewing 15 posts - 556 through 570 (of 819 total)