Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 19,564 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/13/2015)

    OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running to the...

    July 13, 2015 at 10:14 pm

    #1812198

  • RE: Extract the titles from XML

    Hugo Kornelis (7/13/2015)

    SQLRNNR (7/13/2015)

    I see stats, memory grant info, cpu requirements, duration, number of pages, cost (granted it is based off some smoke and magic), number of rows, and even...

    July 13, 2015 at 10:13 pm

    #1812197

  • RE: Extract the titles from XML

    Scott Coleman (7/13/2015)

    In my experience, the inefficiency of flat files comes from my time spent debugging ETL packages when boneheaded third parties don't know how to format them correctly. ...

    July 13, 2015 at 4:16 pm

    #1812172

  • RE: Extract the titles from XML

    Eirikur Eiriksson (7/13/2015)

    SQLRNNR (7/13/2015)

    Maybe so, but look at the XML plans for the larger data set versus the small data set - same plan. By using the text() it...

    July 13, 2015 at 4:11 pm

    #1812170

  • RE: Extract the titles from XML

    TomThomson (7/13/2015)

    Eirikur Eiriksson (7/13/2015)

    This is a very trivial example, the structure of the XML and the size makes it ill fit for any performance testing.

    😎

    Yes, quite so. 😎

    Doing it...

    July 13, 2015 at 2:19 pm

    #1812126

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/13/2015)

    Steve Jones - SSC Editor (7/13/2015)

    Alvin Ramard (7/11/2015)

    Hopefully you'll submit it for SQL Saturday in Memphis, hopefully later this year. 🙂

    When is Memphis?

    We're hoping to have...

    July 13, 2015 at 2:13 pm

    #1812124

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/13/2015)

    Brandie Tarvin (7/11/2015)

    Kind of irked this morning. Found out this morning that the SQL Saturday call for speakers in Orlando closed after only a week.

    Usually...

    July 13, 2015 at 12:39 pm

    #1812105

  • RE: Extract the titles from XML

    Mikael Eriksson SE (7/13/2015)

    I guess this is the preferred form.

    SELECT

    col.value('(Title/text())[1]', 'varchar(50)') AS 'Book'

    FROM @x.nodes('/root/Books/Book') a(col)

    Using text() in the values clause removes one call to a...

    July 13, 2015 at 11:40 am

    #1812090

  • RE: Are the posted questions getting worse?

    GilaMonster (7/13/2015)

    SQLRNNR (7/13/2015)

    GilaMonster (7/13/2015)

    Yes, yes, yes, yes!!!!!!!!

    Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony

    Congrats on the latest degree. Was...

    July 13, 2015 at 11:04 am

    #1812081

  • RE: Are the posted questions getting worse?

    GilaMonster (7/13/2015)

    Yes, yes, yes, yes!!!!!!!!

    Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony

    Congrats on the latest degree. Was this the...

    July 13, 2015 at 9:48 am

    #1812052

  • RE: Extract the titles from XML

    TomThomson (7/13/2015)

    Jeff Moden (7/13/2015)

    The correct answer isn't actually available. The correct answer should be to "hunt down the moroff that used XML to transmit purely flat data and introduce...

    July 13, 2015 at 8:10 am

    #1811988

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/11/2015)

    Kind of irked this morning. Found out this morning that the SQL Saturday call for speakers in Orlando closed after only a week.

    Usually the call for speakers is...

    July 11, 2015 at 1:03 pm

    #1811821

  • RE: Adventureworks database for SQL Server 2016

    Echoing what has been said. Just use the 2014 version of AW. The database likely won't change much for 2016. It hasn't really changed in that last few releases.

    July 11, 2015 at 1:01 pm

    #1811820

  • RE: Before SSMS...Server 7

    malcolm.garbett (7/11/2015)

    Hi Lowell,

    Many thanks for rapid response.

    Will attempt the connection from SSMS on Monday.

    (Here's hoping my predecessors in the job have left the login password in the documentation!)

    Hopefully the environment...

    July 11, 2015 at 9:49 am

    #1811810

  • RE: Database mirroring database are in suspend status

    Database admin(DBA) (7/10/2015)

    Thank you for your quick response.

    shrinking the log files on primary server. As i understand it will impact on performance and it will increase the log file again.

    because...

    July 10, 2015 at 5:10 pm

    #1811787

Viewing 15 posts - 1,171 through 1,185 (of 19,564 total)