Forum Replies Created

Viewing 15 posts - 4,801 through 4,815 (of 7,484 total)

  • RE: Model Database

    Koen Verbeeck (2/22/2012)


    Carlo Romagnano (2/22/2012)


    Koen Verbeeck (2/22/2012)


    Damn you MSDN!

    Any documentation that supports the correct answer?

    I found this: http://msdn.microsoft.com/en-us/library/ms190249.aspx

    It states that:

    To change the default values for any one of the database...

  • RE: Model Database

    Henrico Bekker (2/22/2012)


    After the comments, I think its safe to say:

    Yes, model can be set to Read_Only

    No, it wont affect new databases created?

    It depends how they are created.

    If they are...

  • RE: Database Restore

    Nice straightforward question, and good discussion. Thanks, Stuart.

  • RE: Dynamic update query

    Eugene Elutin (2/21/2012)


    I guess it's not hard to find out that I'm not a native English speaker, just check my signature...

    😉

    Signatures sometimes don't work for those purposes; which (if any)...

  • RE: Dynamic update query

    Jeff Moden (2/21/2012)


    BWAA-HAAA!!!! "English" IS my first language but that doesn't stop me from making similar "mistrakes". 😛 I suppose because of my own ineptitude in the written...

  • RE: Dynamic update query

    fahey.jonathan (2/20/2012)


    This may not be the best way, but it works for my current situation. I create a procedure that lists all the columns as parameters, with "default" values...

  • RE: EXECUTE

    Henrico Bekker (2/20/2012)


    So as it stands, your reply to Satish seems to me to be nothing other than inaccurate nonsense.

    next time, I'll run it past you, to ensure it meets...

  • RE: Today's Random Word!

    Revenant (2/20/2012)


    Dean Martin

    Frank Sinatra

  • RE: Are the posted questions getting worse?

    Since many good sf authors have concentrated to a large extent on female characters (James H Schmitz, Andre Norton, Elizabeth Moon, David Weber just to name two...

  • RE: EXECUTE

    Henrico Bekker (2/16/2012)


    actually not. 2 statements, not a single batch query.

    There aren't two statements, there are 6. If you'd said "two batches of statements" instead of "two statements" the...

  • RE: Hash Join

    The trouble with this question is that adding an index on the the columns being joined in one of the tables (whether or not it's a unique index) can only...

  • RE: Dynamic update query

    Jeff Moden (2/19/2012)


    rajeev_vandakar-782919 (2/18/2012)


    Hi,

    There is a table with 30 to 40 columns and hardly few columns may get updated by the user. We can't say which column(s) may get updated,...

  • RE: SOPA and Censorship

    Jeff Moden (2/19/2012)Gosh... I know it's Sunday (well, early Monday now by my watch) but with more than 24 views, I hope more than 4 people take the poll.

    Thanks, folks.


    Well,...

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (2/19/2012)


    Steve Jones - SSC Editor (2/19/2012)


    I think we have some of the changes surfacing in the Recent Activity. We do create threads, and have wanted discussions for scripts, so...

  • RE: T-SQL Performance 1

    Cliff Jones (2/18/2012)


    DBA_Dom (2/17/2012)


    bitbucket-25253 (2/17/2012)


    SQL Kiwi (2/17/2012)


    Cliff Jones (2/17/2012)


    Interesting but I don't think I want my developers to discover the FORCESEEK hint.

    This is completely the wrong approach, in my opinion....

Viewing 15 posts - 4,801 through 4,815 (of 7,484 total)