Forum Replies Created

Viewing 15 posts - 61 through 75 (of 672 total)

  • RE: Table space usage 2

    I guess the bigest thing I learned from the QOD today is to make certain you have done your research and fully tested what you are saying BEFORE telling...

    November 16, 2011 at 1:37 pm

    #1408852

  • RE: Table space usage 2

    jeff.mason (11/16/2011)

    SanDroid (11/16/2011)

    Now if I could only determine why me, and others still see error 1105 when working with the table the way you mentioned. Could it be that all...

    November 16, 2011 at 1:33 pm

    #1408847

  • RE: Table space usage 2

    Hugo Kornelis (11/16/2011)

    fhanlon (11/16/2011)

    I like the question but the answer says:

    Since 200,474 pages equates to about 1.53 GB, you will not get error 1105.

    I ran this code and I...

    November 16, 2011 at 1:30 pm

    #1408841

  • RE: Table space usage 2

    Hugo Kornelis (11/16/2011)

    SanDroid (11/16/2011)

    I was editing my original post while you read and resonded to this. The original post did not comunicate what I intended.

    No problem, that can happen....

    November 16, 2011 at 1:10 pm

    #1408828

  • RE: Table space usage 2

    Hugo Kornelis (11/16/2011)

    Even after rereading the entire discussion, I fail to see wherer others point out errors that relate to the data page size. Can you elaborate, please?

    I was refering...

    November 16, 2011 at 1:03 pm

    #1408826

  • RE: Table space usage 2

    jeff.mason (11/16/2011)

    If I understand your question, this should address it. Run the first two batches first, investigate the indexes, and then run the third batch. No errors.

    ........

    So...

    November 16, 2011 at 12:31 pm

    #1408810

  • RE: Table space usage 2

    jeff.mason (11/16/2011)

    SanDroid, you have me totally confused. Hugo said that if you don't specify NONCLUSTERED on creation of a Primary Key on a table that has has no clustered...

    November 16, 2011 at 11:05 am

    #1408767

  • RE: Table space usage 2

    Reposting Edit as new post.

    Hugo Kornelis (11/16/2011)

    Ouch, that is a very embarassing mistake. Can you please elaborate on which of my statements you mean, and which articles they contradict? I...

    November 16, 2011 at 10:41 am

    #1408750

  • RE: Table space usage 2

    fhanlon (11/16/2011)

    I like the question but the answer says:

    Since 200,474 pages equates to about 1.53 GB, you will not get error 1105.

    I ran this code and I got error...

    November 16, 2011 at 10:27 am

    #1408737

  • RE: Table space usage 2

    Hugo Kornelis (11/16/2011)

    Again, thanks for all the nice and encouraging comments. I have now decided to continue with the series. Sorry for those who did not like it and would...

    November 16, 2011 at 9:29 am

    #1408680

  • RE: Table space usage 2

    Hugo Kornelis (11/16/2011)

    Quick message to those who arrive here: I am aware that this question involves a lot of calculations - much more hard work than normal questions. So my...

    November 16, 2011 at 8:42 am

    #1408631

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

    SanDroid (11/14/2011)

    Please supply your reference in any answer you provide. For example a link to the internet or the name of the book that backs up your post.

    For everyone...

    November 14, 2011 at 9:58 am

    #1407361

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

    Sean Lange (11/14/2011)

    SanDroid (11/14/2011)

    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...

    November 14, 2011 at 8:59 am

    #1407254

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

    Cadavre (11/14/2011)

    SanDroid (11/14/2011)

    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...

    November 14, 2011 at 8:51 am

    #1407240

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

    GSquared (11/14/2011)

    SanDroid (11/14/2011)

    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...

    November 14, 2011 at 8:42 am

    #1407228

Viewing 15 posts - 61 through 75 (of 672 total)

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy