Forum Replies Created

Viewing 15 posts - 15,031 through 15,045 (of 39,970 total)

  • RE: Fantasy Football 2011

    SQLDCH (10/26/2011)


    The Steelers play the Niners in a Monday night game, will hopefully be attending that one. I do my best to hit the games when the Steelers are...

  • RE: How to divide on row by another

    Yes, I think some running total is needed. Something like this: http://www.sqlservercentral.com/articles/T-SQL/68467/

    The problem is that you cannot do the division in the same way as you're doing the multiplication since...

  • RE: Fill Factor

    A lower fill factor should result in lower fragmentation, since you will get more new rows on the pages before they split, but over time, you might continue to get...

  • RE: How to divide on row by another

    I am getting two rows from your test script, with the values of 48 and 959.999

    Is that correct? It's hard to know what's not working. Division operations work the same...

  • RE: The HR Sorecard

    L' Eomot Inversé (10/25/2011)


    I agree it's necessary and should be there, but I don't agree that it's always an overhead.

    ...

    Also remember that "overhead" doesn't mean "not valuable" or "not necessary"....

  • RE: The HR Sorecard

    djackson 22568 (10/25/2011)


    IT does not generate revenue no matter how you want to measure it. We cost money. Hopefully if we do our job right we allow the...

  • RE: Fantasy Football 2011

    Sorry you missed the game. I heard it was pretty good.

    I didn't get to any games last year. Too busy, and didn't want to spend 8-10 hours down there with...

  • RE: failed 70-432

    Sorry to hear that, but glad you're not discouraged.

    I don't have any more great prep, but I'd go through the list of things on the MS exam site and make...

  • RE: index on big table

    I stand corrected then. It was always my understanding physical order was maintained inside pages.

  • RE: Are the posted questions getting worse?

    Nothing wrong with basic phones, despite what my kids think. If you use it to just make calls, or text a bit, that's fine.

    However for me, I'm more productive. I...

  • RE: index on big table

    Yes and no, and I shouldn't write physical order. I realize what Gail is saying and it is true that the clustered index doesn't mean that the extents and pages...

  • RE: index on big table

    The clustered index is the physical order, so it helps in terms of ordering the data back if the table is scanned. So typically I try to cluster on columns...

  • RE: Need to delete a row from the source table

    In your first query, you aren't joining to the table you are deleting from.

    What you should do is write a SELECT query first to find out what will be found....

  • RE: Are the posted questions getting worse?

    What's funny is that it seems that people see the devices so differently. My wife misses her Blackberry, but likes her Android (Samsung Galaxy S, Android) more than her iPhone...

  • RE: The HR Sorecard

    Joe Johnson-482549 (10/25/2011)


    Lempster (10/25/2011)


    It's a nice idea, but would involve getting access to HR data which, in my experience, HR departments tend to be rather twitchy about!

    In the US, Sarbanes-Oxley...

Viewing 15 posts - 15,031 through 15,045 (of 39,970 total)