Forum Replies Created

Viewing 15 posts - 511 through 525 (of 5,590 total)

  • RE: Are the posted questions getting worse?

    TomThomson (5/20/2014)

    Steve Jones - SSC Editor (5/20/2014)

    Who's getting a Surface 3? Or wants one?

    Up in the air on this whole thing, but I'll admit it's tempting, depending on price.

    http://www.microsoft.com/en-us/news/press/2014/may14/05-20surfacepr.aspx

    Why...

    May 21, 2014 at 6:29 am

    #1715309

  • RE: Are the posted questions getting worse?

    Sean Lange (5/8/2014)

    Luis Cazares (5/8/2014)

    jcrawf02 (5/8/2014)

    WayneS (5/8/2014)

    Ed Wagner (5/8/2014)

    No real surprise there. I checked out the site quite some time ago and remarked to myself how miserable the questions...

    May 9, 2014 at 1:35 pm

    #1712320

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/8/2014)

    No real surprise there. I checked out the site quite some time ago and remarked to myself how miserable the questions were. I also saw that...

    May 8, 2014 at 10:03 am

    #1711946

  • RE: Cumulative sum of previous rows

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

    May 8, 2014 at 10:01 am

    #1711943

  • RE: Cumulative sum of previous rows

    rwatkins 25267 (5/8/2014)

    I agree with SimonC, the RANGE clause is the better solution to the Running Total problem for read operations.

    I disagree. For running aggregations (including totals), you need to...

    May 8, 2014 at 9:52 am

    #1711941

  • RE: Are the posted questions getting worse?

    hisakimatama (5/7/2014)

    SQLRNNR (5/6/2014)

    hisakimatama (5/6/2014)

    SQLRNNR (5/6/2014)

    hisakimatama (5/1/2014)

    Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

    Anyone else from The Thread planning to attend...

    May 7, 2014 at 10:23 am

    #1711605

  • RE: Open Source the MCM

    Keith Tate (4/23/2014)

    Taking the questions/scenarios out of the context of the lab environment (strange environment, limited time, no internet just BOL) would detract from the experience that most of us...

    April 23, 2014 at 3:39 pm

    #1708264

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/19/2014)

    Greg Edwards-268690 (4/19/2014)

    Steve -

    Although attention to details is part of or job, I wonder if something could be done at some time to at least...

    April 20, 2014 at 9:17 am

    #1707328

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (4/16/2014)

    OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and no...

    April 16, 2014 at 2:02 pm

    #1706579

  • RE: Are the posted questions getting worse?

    dwain.c (4/3/2014)

    Steve Jones - SSC Editor (4/3/2014)

    dwain.c (4/3/2014)

    Many thanks to Steve for syndicating my blogs on SSC:

    DwainCSQL[/url]

    And my apologies for making you work so hard at it.

    You are welcome and...

    April 3, 2014 at 8:34 pm

    #1703169

  • RE: Reaping the benefits of the Window functions in T-SQL

    Eirikur,

    This is an excellent modification to an already excellent function. Very well done!!! (And it was such a simple change at that.)

    Jeff Moden (3/24/2014)

    Eirikur asked me to review it (seems...

    April 3, 2014 at 4:19 pm

    #1703130

  • RE: Are the posted questions getting worse?

    Sean Lange (4/3/2014)

    Greg Edwards-268690 (4/3/2014)

    it was clear they had no idea what they wanted or needed.

    But finish it by Friday.

    This is an everyday occurrence at my job.

    You have until Friday?...

    April 3, 2014 at 3:26 pm

    #1703112

  • RE: Are the posted questions getting worse?

    Ed Wagner (3/28/2014)

    WayneS (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces of sh code...

    March 28, 2014 at 12:15 pm

    #1701272

  • RE: Are the posted questions getting worse?

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces of sh code and it's slower...

    March 27, 2014 at 8:48 pm

    #1700962

  • RE: rewrite cursor to set based

    Well, hello there.

    Luis - thanks for linking to my article. However, I'm afraid that it doesn't do much for helping to learn how to remove cursors. For that task, my...

    March 27, 2014 at 8:43 pm

    #1700961

Viewing 15 posts - 511 through 525 (of 5,590 total)