Forum Replies Created

Viewing 15 posts - 76 through 90 (of 673 total)

  • RE: Why is "Select *" bad in any SQL code?

    Ninja's_RGR'us (11/14/2011)


    You mean aside from ddl change, performance, network overuse, column order change, performance, indexes being useless, not seing the list of columns when working on the code?

    so aside from...

  • RE: Heath Normal Form

    L' Eomot Inversé (11/13/2011)


    bitbucket-25253 (11/12/2011)


    Without prior knowledge of the QOD author I surmised it was you...

    Now a general question for yourself .... in your experiences, around the world, what would...

  • RE: Heath Normal Form

    First let me say interesting question.

    I had heard about this in the 80's but had really dropped it along with cars that run on water and the gushot...

  • RE: SQL_VARIANT 1

    vk-kirov (11/10/2011)


    Nils Gustav Stråbø (11/10/2011)


    Good question, but I'm not sure that the explanation is 100% correct.

    I'm sure that the part of the explanation was deleted by accident:

    Because values from different...

  • RE: Real Time Dangers

    I find great humor in reading an article on Real Time computer processes that seems to need a spell check.

    What does "oif" mean anyway? :w00t:

    Seriously though, the more we...

  • RE: Network Protocals

    Koen Verbeeck (11/6/2011)


    TCP/IP needs a network adaptor. Isn't that hardware as well? 😛

    A Network Card is not considered specialized hardware 😛

    VIA requires very special hardware allowing the server to use...

  • RE: Network Protocals

    Nice easy Monday question. Thank you.

    Seriously suprised how many people chose Shared Memory.

  • RE: Mirroring

    Good Question!

    Thanks for the easy Friday question.

    I also find it interesting that only 35% so far have selected the correct answer.

  • RE: Update table

    Not certain why I selected the "right" answer, but got the question wrong?

    I know there is some debate on the syntax, etc... but did not think it was...

  • RE: The Cost of Architecture

    Steve,

    Great article. Like how you used the picture of Falling Water to set the tone.

    Great example of how something can be done right the very first time it is...

  • RE: Out of order

    Dave62 (10/21/2011)


    SanDroid (10/21/2011)


    ...I should have been more specific in my question.

    Does using a "TOP 99999999" statement with an "order by" in a VIEW against an actual table with less than...

  • RE: Out of order

    Dave62 (10/21/2011)


    SanDroid (10/21/2011)


    ......

    It should work wether there are more or less records. You can even use a variable to limit the number of records returned or return them all.

    ......

    I should...

  • RE: Out of order

    Dave62 (10/21/2011)


    ....

    I'm glad though that there hasn't been a lot of "trick question... I want my point back..." responses. :rolleyes:

    That's most likely becuase there is a big difference between a...

  • RE: Out of order

    Mighty (10/21/2011)


    Carlo Romagnano (10/21/2011)


    CREATE VIEW vw_clients AS

    SELECT TOP 100 PERCENT Code, Name FROM Clients

    ORDER BY Code

    I am curious to know if the VIEW above always returns records in sorted...

  • RE: Protecting Data

    Kevin Gill (10/19/2011)


    Miles Neale (10/19/2011)


    Kevin Gill (10/19/2011)


    SanDroid (10/19/2011)


    Kevin Gill (10/19/2011)


    Just to answer one of your points, I'm not worried about rouge developers, as they're easy to spot by their colouring,...

Viewing 15 posts - 76 through 90 (of 673 total)