Forum Replies Created

Viewing 15 posts - 8,596 through 8,610 (of 19,564 total)

  • RE: Are the posted questions getting worse?

    mtillman-921105 (9/20/2011)

    Ahh, basking in the Great CELKO wisdom:

    "We use sets, not loops; loop are like eating babies. You might do it once but you do not tell people about it."...

    September 20, 2011 at 4:10 pm

    #1384258

  • RE: Are the posted questions getting worse?

    Evil Kraig F (9/20/2011)

    Remi, I'd say you need a hobby, but apparently you already had one... Poor Lowell.

    What will Lowell ever do with himself now?! Shame on you, Remi....

    September 20, 2011 at 3:41 pm

    #1384225

  • RE: Are the posted questions getting worse?

    SQL Kiwi (9/20/2011)

    GilaMonster (9/20/2011)

    SQL Kiwi (9/20/2011)

    Amateurs.

    SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)

    Apostrophes all gone :laugh:

    Memory too. :crash:

    I actually tried running this command before I posted it. :pinch:

    I clicked 'cancel' nearly ten minutes ago...

    September 20, 2011 at 1:33 pm

    #1384124

  • RE: Are the posted questions getting worse?

    GilaMonster (9/20/2011)

    SQLRNNR (9/20/2011)

    GSquared (9/20/2011)

    GilaMonster (9/20/2011)

    GSquared (9/20/2011)

    L' Eomot Inversé (9/20/2011)

    WayneS (9/20/2011)

    GSquared (9/20/2011)

    Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a...

    September 20, 2011 at 1:06 pm

    #1384107

  • RE: Preparing for Disaster

    Talk about a disaster upon a disaster.

    Could have added that all backups have been erased.

    September 20, 2011 at 12:59 pm

    #1384102

  • RE: Are the posted questions getting worse?

    GSquared (9/20/2011)

    GilaMonster (9/20/2011)

    GSquared (9/20/2011)

    L' Eomot Inversé (9/20/2011)

    WayneS (9/20/2011)

    GSquared (9/20/2011)

    Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. ...

    September 20, 2011 at 12:52 pm

    #1384100

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/20/2011)

    WayneS (9/16/2011)

    GilaMonster (9/16/2011)

    I've been considering an article for Simple-Talk on that, to cover the subject properly and clear all the misconceptions floating around would take...

    September 20, 2011 at 10:29 am

    #1383993

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (9/20/2011)

    You changed your name?

    September 20, 2011 at 10:13 am

    #1383974

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/20/2011)

    Brandie Tarvin (9/20/2011)

    Whoot! So, who wants to go to Curacoa?

    http://www.sqlsaturday.com/eventhome.aspx - SQL Saturday 103

    Self plug...

    This is a unique event where you can mix business with pleasure. Think...

    September 20, 2011 at 10:09 am

    #1383970

  • RE: Are the posted questions getting worse?

    GilaMonster (9/20/2011)

    Brandie Tarvin (9/20/2011)

    CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?

    <pedantic>

    CTEs don't start with a ';', no more than an english sentence starts...

    September 20, 2011 at 10:05 am

    #1383966

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/20/2011)

    Whoot! So, who wants to go to Curacoa?

    http://www.sqlsaturday.com/eventhome.aspx - SQL Saturday 103

    Trying to work that into the plans. Maybe SQLCruise should coordinate something with Roy?

    September 20, 2011 at 10:03 am

    #1383963

  • RE: SubQuery

    Kenneth Wymore (9/20/2011)

    SQLRNNR (9/19/2011)

    Kenneth Wymore (9/19/2011)

    Any idea as to why they would allow this behavior in a join? Seems to me like it would actually introduce more confusion than convenience.

    I...

    September 20, 2011 at 9:36 am

    #1383927

  • RE: how to load 100 flat files source in ssis

    Do you know beforehand what format each file is?

    September 19, 2011 at 10:39 pm

    #1383622

  • RE: Table Access Order

    SQL Kiwi (9/19/2011)

    SQLRNNR (9/19/2011)

    Thanks for another superb question Paul.

    Thanks for leaving a comment - I had completely forgotten this was scheduled for today!

    The timing of the question is good. ...

    September 19, 2011 at 10:37 pm

    #1383621

  • RE: Views

    Views are more like tables than stored procedures. To find out the usage, you will need to run a trace.

    Alternatively, only allow access to views via stored procedure. ...

    September 19, 2011 at 10:05 pm

    #1383616

Viewing 15 posts - 8,596 through 8,610 (of 19,564 total)