Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 1,413 total)

  • RE: Indexed Views

    quote:


    Excellent article, however, I'm sure the value of indexed views can be communicated just as effectively without preaching to us about denormalization...which...

  • RE: Indexed Views

    quote:


    Changes once loaded dont update the forum title, I'll fix tonight.


    No problem, I think most...

  • RE: Indexed Views

    quote:


    Sorry, am I blind or does thread subject and article title not match?

    I see 'What is denormalization' along with the articles about...

  • RE: Cluster That Index - Part 2

    quote:


    If a data page is split, there is a pointer added to the original page to point toward the new page (forward...

  • RE: Is XML the Answer?

    quote:


    You have a sparse data situation when most of your records don't have actual data in them, i.e., they have a lot...

  • RE: Cluster That Index - Part 2

    About the title, "Cluster that index - part 2", it should have been either simply "Forward pointers" or maybe part 3 och Cluster that index, since there is already a...

  • RE: Is XML the Answer?

    quote:


    I also find it somewhat amusing that people still believe relational databases are inheriently better than hierarchal. There's no one solution fits...

  • RE: Is XML the Answer?

    Hats off and a standing ovation to Don! You are so right in everything you write in the article. Some comments to the other comments you have received so far:

  • RE: Cluster That Index - Part 2

    quote:


    Just read both of them, I am always amazed that there is always something new to learn about indexing. Excellent article, hesitant...

  • RE: SQL and Java Go on a Date

    Sorry for the error in the HTML code of the part called Back to Java that makes it necessary to scroll the page to read, I think it is being...

  • RE: Cluster That Index! Part Two

    quote:


    Great Article. One addition comment about page splitting from your example. If your are worried about page slitting because of heavy inserts...

  • RE: Cluster That Index! Part Two

    quote:


    this is no comment on your article, but on your homepage.

    The link to your discussion forum yields a

    Fatal error: Call to...

  • RE: Execution plan for function

    quote:


    As each execution of a SP normally generates it's own set of statistics (and has it's own query plan), there would have...

  • RE: Unix to SQL Server connection

    Have you tried without host name, i.e. ip address directly?

    --

    Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

    http://www.sql.nu

  • RE: IF in SELECT

    IF is a statement level conditional test, CASE is row level.

    --

    Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

    http://www.sql.nu

Viewing 15 posts - 1,051 through 1,065 (of 1,413 total)