Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/19/2016)

    Hi all,

    I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if anyone has...

    September 19, 2016 at 12:08 pm

    #1901703

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/19/2016)

    Brandie Tarvin (9/19/2016)

    And THIS[/url], folks, is why backups are important.

    http://www.sqlservercentral.com/articles/Editorial/146482/

    Whoops. Yeah. I haven't read my newsletter yet today.

    September 19, 2016 at 10:50 am

    #1901691

  • RE: Are the posted questions getting worse?

    And THIS[/url], folks, is why backups are important.

    September 19, 2016 at 10:41 am

    #1901686

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/19/2016)

    David Burrows (9/19/2016)

    Ed Wagner (9/19/2016)

    ChrisM@Work (9/19/2016)

    Eirikur Eiriksson (9/18/2016)

    Now where is that crystal ball again?

    😎

    You're going to need a pair of those. The OP (or should that be "perp"?)...

    September 19, 2016 at 10:40 am

    #1901685

  • RE: Are the posted questions getting worse?

    I HAVE THE POWER!!!!

    Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug fix"). I'm not...

    September 19, 2016 at 7:52 am

    #1901626

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (9/15/2016)

    Anyone here planning to (or thinking about) going to Live! 360 Orlando?

    As a speaker, I have been given a special registration code that triggers a cheaper price $500...

    September 16, 2016 at 11:59 am

    #1901438

  • RE: SQL Code QA

    The Dixie Flatline (9/15/2016)

    I don't think I've ever done a RIGHT JOIN in production. :ermm:

    I have a power user who does it all the time because he doesn't seem...

    September 15, 2016 at 11:56 am

    #1901188

  • RE: SQL Code QA

    MMartin1 (9/15/2016)

    A pet peeve of mine is when the columns used in the select clause as the result of joins are not prefixed. You may know that someColumn came from...

    September 15, 2016 at 11:52 am

    #1901186

  • RE: SQL Agent Job Shows Running for Days, but Not Really Running

    jerry-621596 (9/15/2016)

    Brandie, these two jobs didn't cross over to a linked server. If I find anything common as I continue to research this I will let you know.

    Please do. And...

    September 15, 2016 at 11:51 am

    #1901184

  • RE: Blocked Process Alert issues

    mcliffordDBA (9/6/2016)

    What was the outcome? We are having a similar issue, but I can't capture the block.

    Oh, wow. It's been so long ago. We ended up having to do an...

    September 15, 2016 at 7:12 am

    #1901103

  • RE: t-sql 2012 case statement issue

    wendy elizabeth (9/10/2016)

    In a t-sql 2012, I have the following case statement:

    CASE

    WHEN (CalendarSchool.schoolLevelOPS IN ('All', 'Elem') AND ScheduleStructure.name <> 'High/Middle...

    September 15, 2016 at 6:27 am

    #1901081

  • RE: SQL Agent Job Shows Running for Days, but Not Really Running

    Usually when this happens in my environment, some sort of network blip has killed a connection to another server (the jobs that tend to do this are jobs pointing to...

    September 15, 2016 at 6:24 am

    #1901080

  • RE: SQL Code QA

    Fast.Eddie (9/7/2016)

    Good Afternoon All, This is my first post.

    I created the below code and if works fine. However my DBA said "It does the job but is clunky" how could...

    September 15, 2016 at 6:21 am

    #1901078

  • RE: SQL Code QA

    The Dixie Flatline (9/7/2016)

    Did he say it looks clunky or it runs clunky?

    I think your DBA is being really picky unless you have company standards for formatting,...

    September 15, 2016 at 6:17 am

    #1901076

  • RE: SQL Code QA

    Luis Cazares (9/7/2016)

    colin.dunn (9/7/2016)

    Put the join ON clauses on the same line since they were so short.

    I usually have my ON clauses on the same line as my JOIN, but...

    September 15, 2016 at 6:13 am

    #1901075

Viewing 15 posts - 1,456 through 1,470 (of 9,715 total)