Forum Replies Created

Viewing 15 posts - 301 through 315 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/12/2014)

    Stefan Krzywicki (5/12/2014)

    TomThomson (5/12/2014)

    Ed Wagner (5/12/2014)

    Sean Lange (5/12/2014)

    Lynn Pettis (5/12/2014)

    Sean Lange (5/12/2014)

    Ed Wagner (5/12/2014)

    It sure is nice to hear that others remember the old "alt codes". I...

    May 12, 2014 at 1:44 pm

    #1712838

  • RE: Are the posted questions getting worse?

    TomThomson (5/12/2014)

    Ed Wagner (5/12/2014)

    Sean Lange (5/12/2014)

    Lynn Pettis (5/12/2014)

    Sean Lange (5/12/2014)

    Ed Wagner (5/12/2014)

    It sure is nice to hear that others remember the old "alt codes". I remember being able to...

    May 12, 2014 at 1:37 pm

    #1712835

  • RE: Cumulative sum of previous rows

    bkubicek (5/8/2014)

    Stefan Krzywicki (5/8/2014)

    Good article.

    I'm not sure what you meant by this though

    I found something new in SQL Server 2012. You can now add an order by to the over(...

    May 8, 2014 at 10:56 am

    #1711964

  • RE: Cumulative sum of previous rows

    WayneS (5/8/2014)

    Stefan Krzywicki (5/8/2014)

    Good article.

    I'm not sure what you meant by this though

    I found something new in SQL Server 2012. You can now add an order by to the over(...

    May 8, 2014 at 10:55 am

    #1711963

  • RE: Cumulative sum of previous rows

    Good article.

    I'm not sure what you meant by this though

    I found something new in SQL Server 2012. You can now add an order by to the over( partition by and...

    May 8, 2014 at 9:51 am

    #1711939

  • RE: Are the posted questions getting worse?

    Paul White (5/6/2014)

    Stefan Krzywicki (5/6/2014)

    I'm trying to make sure I understand it well enough to explain it because I'm trying to convince people to stop using it. They always have...

    May 6, 2014 at 12:28 pm

    #1711219

  • RE: Are the posted questions getting worse?

    Sean Lange (5/6/2014)

    Stefan Krzywicki (5/6/2014)

    GilaMonster (5/6/2014)

    Stefan Krzywicki (5/6/2014)

    Maybe it is just that if a split has occurred, NOLOCK can return bad data, even if the split happened awhile ago?

    A...

    May 6, 2014 at 9:04 am

    #1711118

  • RE: Are the posted questions getting worse?

    GilaMonster (5/6/2014)

    It's exactly what I explained above. Existing rows in the table (previously committed) being missed because the page those existing rows is on is splitting due to an insert/update...

    May 6, 2014 at 9:03 am

    #1711116

  • RE: Are the posted questions getting worse?

    GilaMonster (5/6/2014)

    Stefan Krzywicki (5/6/2014)

    Maybe it is just that if a split has occurred, NOLOCK can return bad data, even if the split happened awhile ago?

    A scan under read uncommitted...

    May 6, 2014 at 8:47 am

    #1711104

  • RE: Are the posted questions getting worse?

    GilaMonster (5/6/2014)

    No, it was not me that pointed it out, because for a page split to occur, there must be an insert/update operation occurring. SQL doesn't randomly, when it's bored,...

    May 6, 2014 at 8:34 am

    #1711093

  • RE: Are the posted questions getting worse?

    venoym (5/6/2014)

    Stefan Krzywicki (5/6/2014)

    I thought I remembered a discussion here months ago about NOLOCK possibly returning bad data even when there's no changed to the table being queried, but now...

    May 6, 2014 at 8:24 am

    #1711088

  • RE: Are the posted questions getting worse?

    I thought I remembered a discussion here months ago about NOLOCK possibly returning bad data even when there's no changed to the table being queried, but now I can't find...

    May 6, 2014 at 6:42 am

    #1711027

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (2/25/2014)

    rodjkidd (2/25/2014)

    Steve Jones - SSC Editor (2/24/2014)

    I went to the Rock and Roll Hall of Fame in Cleveland a few weeks ago. It was pretty neat to...

    February 25, 2014 at 7:46 pm

    #1692120

  • RE: Are the posted questions getting worse?

    Cody K (2/17/2014)

    GilaMonster (2/17/2014)

    A little. As questions go, that's a relatively decent one.

    "the file is there. I tried with extensions also like sample.csv and all but no luck. I don...

    February 17, 2014 at 7:44 am

    #1689526

  • RE: Are the posted questions getting worse?

    Steve Thompson-454462 (2/14/2014)

    Stefan Krzywicki (2/13/2014)

    Anyone know of a good ASP.NET analogue to SQLServerCentral.com? I have questions and I'm not sure where is good.

    I like the Red Gate sister site: SimpleTalk[/url].

    Haven't...

    February 14, 2014 at 8:34 am

    #1689104

Viewing 15 posts - 301 through 315 (of 2,838 total)