Forum Replies Created

Viewing 15 posts - 40,471 through 40,485 (of 49,571 total)

  • RE: "Answered" Posts

    The ones in green are the flagged answers.

  • RE: Are the posted questions getting worse?

    Kit G (3/9/2009)


    Lynn Pettis (3/9/2009)


    I have had similiar requests, not security fixes but one-on-one help. Not like I have anything else do to all day.

    Perhaps you should send back...

  • RE: Self blocking

    balbirsinghsodhi (3/9/2009)


    I am running this query on SQL2000 server.

    Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get...

  • RE: Are the posted questions getting worse?

    GSquared (3/9/2009)


    Had to group by something that wasn't appearing in the Select list. It's Brandi Tarvin who made that claim, and she actually backed it up with some examples....

  • RE: Restore SQL2008 File to SQL2005

    GSquared (3/9/2009)


    I think, if you downgrade the compatibility level of the database from 2008 to 2005 (100 to 90), detach the database from the 2008 server, copy the file over,...

  • RE: The Myth of "Content is King, No Animation/Sound/Java/etc"

    Spam. Reported to mod. No replies please.

  • RE: Group By clause

    Brandie Tarvin (3/9/2009)[hr Group By doesn't guarantee distinct results.

    Books Online


    Groups a selected set of rows into a set of summary rows by the values of one or more columns or...

  • RE: Are the posted questions getting worse?

    K. Brian Kelley (3/9/2009)


    Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:

    "If you do not understand what this...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)


    GSquared (3/9/2009)


    Grant Fritchey (3/9/2009)


    All right! Lynn is turning into one of those old school saints who wades in & beats the snot out of the unbelievers.

    That is too...

  • RE: Are the posted questions getting worse?

    Bob Hovious (3/9/2009)


    Gail, weren't you the person who observed that GROUP BY produces the same execution plan

    as DISTINCT?

    Yup. A group by on all columns in a resultset...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)


    You are one of the top 3 people on SSC

    Top 4 actually. Steve, Jeff and Remi are ahead

    so they figure if anyone knows the answer you are sure...

  • RE: Creating a Database Snapshot

    Jose Ianuck (3/9/2009)


    The big problem is to avoid locks or bad performance

    Locks it will avoid, bad performance, maybe , maybe not

    But create a snapshot database, it is so fast....

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)


    I hate it when someone PM's me with a problem/question/additional info that really should be posted on an open forum thread.

    I've been getting a fair few...

  • RE: "Answered" Posts

    Steve Jones - Editor (3/6/2009)


    I'll check them out, but they appear to be down now. Or down from the Denver area.

    Site's back up now. http://sadeveloper.net/forums/default.aspx

    Here's a thread with two replies...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2009)


    You have to wonder what people are being taught when you see code like this:

    ALTER TRIGGER [dbo].[tr_insert]

    ON [dbo].[table1]

    AFTER INSERT...

Viewing 15 posts - 40,471 through 40,485 (of 49,571 total)