Forum Replies Created

Viewing 15 posts - 946 through 960 (of 5,590 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/6/2012)

    Since inception, here are the posts

    Year Mo Posts

    20121249

    201112806

    201111906

    201110862

    20119974

    20118909

    20117837

    20116894

    20115763

    20114812

    20113888

    20112740

    20111798

    201012824

    201011972

    2010101457

    201091613

    201081057

    20107833

    20106492

    20105582

    201041325

    201031575

    201021139

    20101568

    200912810

    200911625

    200910674

    20099508

    20098690

    20097772

    200961167

    200951284

    20094740

    200931018

    20092993

    20091603

    200812364

    200811161

    How about who were the top 5/10/x (your choice) posters...

    January 6, 2012 at 9:21 am

    #1429709

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/6/2012)

    Case insensitive vs case sensitive, one of the reasons I write all my queries and t-sql code as if everything was case sensitive. Don't have to worry...

    January 6, 2012 at 9:17 am

    #1429704

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/30/2011)

    SQLRNNR (12/28/2011)

    How much did that barn cost? I need one that is about 60'x100'

    $100k. 72x140, Big Top Structures.

    Hmm. I think I need to figure...

    December 30, 2011 at 2:05 pm

    #1427126

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/27/2011)

    I am putting the finishing touches on an article. Anybody interested in reviewing/critiquing it?

    Feel free to toss it my way if you so desire...

    December 28, 2011 at 11:08 am

    #1426192

  • RE: Are the posted questions getting worse?

    GilaMonster (12/21/2011)

    Not a DBA, but...

    You may not be one, but you're better than most of them. (BTW - thanks for that!)

    December 21, 2011 at 8:49 am

    #1424296

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (12/20/2011)

    WayneS (12/19/2011)

    bitbucket-25253 (12/19/2011)

    Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. ...

    December 20, 2011 at 1:53 pm

    #1423917

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (12/19/2011)

    Another quirk - those old machines when shut down were restarted by reading a series of commands from a roll of punched paper tape. Doubt if many...

    December 19, 2011 at 4:00 pm

    #1423339

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/15/2011)

    Dev (12/15/2011)

    Brandie Tarvin (12/15/2011)

    Dev (12/15/2011)

    Symptom of cross post:

    SSC refreshes the page while posting.

    Workaround:

    Browser's back button & hit Post. 😉

    Not quite. If you don't refresh the...

    December 15, 2011 at 10:33 am

    #1422104

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/12/2011)

    WayneS (12/9/2011)

    Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a cte....

    December 12, 2011 at 9:05 am

    #1420136

  • RE: Are the posted questions getting worse?

    SQL Kiwi (12/10/2011)

    Turns out the parser is sending 'range between unbounded and current' for both FIRST_VALUE and LAST_VALUE with the CTE. This doesn't cause a problem for FIRST_VALUE (naturally!)...

    December 10, 2011 at 8:02 am

    #1419711

  • RE: Are the posted questions getting worse?

    Hmmm. I think I just found a bug in SQL 2012 - one of the new Analytic functions returns a different value when called from within a cte. Anyone willing...

    December 9, 2011 at 10:01 pm

    #1419677

  • RE: Complex joins

    L' Eomot Inversé (12/6/2011)

    It's another one where I'm surprised by the failure rate - 78% wrong answers is amazing. Does that mean that 78% of people here never write...

    December 7, 2011 at 3:30 pm

    #1418400

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/7/2011)

    Steve Jones - SSC Editor (12/7/2011)

    Koen Verbeeck (12/7/2011)

    Dev (12/7/2011)

    The only valid countries are USA (except a few states), Canada (except Quebec), UK (except North Ireland) and Australia....

    December 7, 2011 at 1:39 pm

    #1418361

  • RE: Slow Running Stored Proceudre

    1. Add an index to the #temp table for the columns that you are grouping by.

    I see a lot of MONTH(CONVERT(SMALLDATEDIME, CONVERT(CHAR(8), TradeDateKey))) calls. It looks like TradeDateKey is an...

    December 5, 2011 at 11:36 am

    #1416935

  • RE: Are the posted questions getting worse?

    Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!

    November 18, 2011 at 2:08 pm

    #1410198

Viewing 15 posts - 946 through 960 (of 5,590 total)