Forum Replies Created

Viewing 15 posts - 13,696 through 13,710 (of 22,213 total)

  • RE: Do you use Facebook?

    I have an account. I do nothing with it except accept all the friend requests that come in. That and delete mafia and farm requests (you people need to get...

  • RE: Database monitoring soft ware

    sqlbuddy123 (1/5/2011)


    I'd prefer Idera's SQL Diagnostic Manager. Thats really a wonderful tool.

    You can even go with Redgate's SQL Monitor. Redgate tools are also excellent and are much cheaper than Idera's.

    Thank...

  • RE: Job Advise

    I'm with Gus. You follow every best practice you can, enforce them as tightly as possible, and then, when the boss says to throw them out the window because of...

  • RE: DB Reverts to Single-User Mode

    Marco V (1/4/2011)


    check the default trace for the alter statement it is located in youre log directory by default.

    Excellent idea. That's very likely in the default trace.

  • RE: DB Reverts to Single-User Mode

    I'm not sure, but it has to be somewhere in the system or attaching to the system. There's no reason for it to just randomly set itself to single user.

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/4/2011)


    Dave Ballantyne (1/4/2011)


    Brandie Tarvin (1/4/2011)


    And I found out I wasn't following Dave either. Silly me.

    Funnily enough , most people arent surprised to find out they are not following...

  • RE: Are the posted questions getting worse?

    GilaMonster (1/4/2011)


    btw Grant, your SSC sig is still listing your old blog.

    Great googly moogly, how many places did I post that silly thing.

    Thanks.

    Good news is, even if people are going...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/4/2011)


    Grant Fritchey (1/4/2011)


    Dave Ballantyne (1/4/2011)


    Grant Fritchey (1/4/2011)


    It really is like launching a nuclear strike, but if you're not getting satisfaction, I'd tweet about it.

    Already did , maybe everyone...

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (1/4/2011)


    Grant Fritchey (1/4/2011)


    It really is like launching a nuclear strike, but if you're not getting satisfaction, I'd tweet about it.

    Already did , maybe everyone was in a holiday...

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (1/4/2011)


    Chris Morris-439714 (1/4/2011)


    Craig Farrell (1/3/2011)


    For anyone following the earlier infringment discussion, some sleuthing around SSC finally revealed the blog owner. A brief PM conversation seems to have...

  • RE: Best stategy for updating a Table with unique id and datastamp

    ibzmiller (1/4/2011)


    That's great Grant. Thanks so much for the information. Really helped.

    I can't see how to mark you as having answered my question. Do we do that on this...

  • RE: Indexes for Booking Search

    GilaMonster (1/4/2011)


    My concern is the comment that was next to the definition of kind:

    /* Kinds: Sale / Purchase */

    If it's 2 values (and nvarchar255 to boot), it's going to be...

  • RE: Indexes for Booking Search

    GilaMonster (1/4/2011)


    Grant Fritchey (1/4/2011)


    the PK is not being used to determine access to the table. That at least suggests you should be looking elsewhere for the PK.

    Not the PK,...

  • RE: Indexes for Booking Search

    Notice how the leading edge of three of the indexes is the [Kind] column. That starts to look like a better candidate for your clustered index than the primary key...

  • RE: Best stategy for updating a Table with unique id and datastamp

    ibzmiller (1/4/2011)


    Hi Guys,

    Thanks for the replies. That's the sort of thing I was looking for. What I would like to know if though, you mentioned using the snapshot, from...

Viewing 15 posts - 13,696 through 13,710 (of 22,213 total)