Forum Replies Created

Viewing 15 posts - 166 through 180 (of 522 total)

  • RE: Model.mdb

    According to http://technet.microsoft.com/en-us/library/ms186388.aspx it can NOT be set as read_only:

    The following operations cannot be performed on the model database:

    Setting the database or primary filegroup to READ_ONLY.

    Oh wait... according to the...

    Best Regards,

    Chris Büttner

    April 15, 2010 at 6:12 am

    #1152033

  • RE: Model.mdb

    Am I missing something? I can actually set the database to read-only:

    ALTER DATABASE MODEL SET READ_ONLY WITH NO_WAIT

    Command(s) completed successfully.

    Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) ...

    Best Regards,

    Chris Büttner

    April 15, 2010 at 12:48 am

    #1151904

  • RE: NULL

    Hugo Kornelis (4/13/2010)

    [wrote lots of good stuff...]

    Thanks for this excellent clarification which deserves an Article on its own! So you better get started! 😀

    Best Regards,

    Chris Büttner

    April 13, 2010 at 2:26 am

    #1150537

  • RE: String length?

    da-zero (4/12/2010)

    A small question:

    isn't the variable @InputStr stored somewhere? As the loop goes on forever, at some point in time that variable will become too large to reside in memory/physical...

    Best Regards,

    Chris Büttner

    April 12, 2010 at 6:42 am

    #1149981

  • RE: String length?

    werner.broser (4/12/2010)

    This is partly true, because as usual conversion will take place, and if possible to convert the string to an integer it would be returned, otherwise an error occurs

    kr/Werner

    We...

    Best Regards,

    Chris Büttner

    April 12, 2010 at 5:34 am

    #1149933

  • RE: Understanding and Using APPLY (Part 1)

    Thank you, Paul. This is great work. Not only the code & explanation, but equally important: the design of the article. Very easy to read with good illustrations & examples....

    Best Regards,

    Chris Büttner

    April 12, 2010 at 1:38 am

    #1149852

  • RE: String length?

    Paul White NZ (4/11/2010)

    First one to whinge about the explanation being 'incomplete' gets a banana :w00t: 😛

    Me want the banana *whingingabouttheexplanation*! 😀

    No results returned, as an infinite loop is invoked....

    Best Regards,

    Chris Büttner

    April 12, 2010 at 1:18 am

    #1149849

  • RE: TRUNCATE

    Paul White NZ (3/30/2010)

    vk-kirov (2/10/2010)

    In the example above, we will see request_mode = Sch-M (schema modification). This is specific to DDL events.

    Not true. From Books Online - Lock Modes:

    Some...

    Best Regards,

    Chris Büttner

    April 6, 2010 at 1:55 am

    #1146334

  • RE: Numeric or Not Numeric

    We already had a similar question before.

    If a number string can be converted to any numeric type, ISNUMERIC returns 1.

    Among the known "issues" with this are:

    money: 1,,,,,,1 is a valid...

    Best Regards,

    Chris Büttner

    February 22, 2010 at 1:19 am

    #1122744

  • RE: Concatenation Cursor

    yordan.georgiev (2/19/2010)

    2005 does not have table variables ...

    It does suport table variables, and so does SQL Server 2000.

    You probably are talking about table variables as parameters.

    Best Regards,

    Chris Büttner

    February 19, 2010 at 12:56 am

    #1121594

  • RE: LOCK

    Steve Jones - Editor (2/17/2010)

    Edited. I'll clean up points in the am.

    Sorry, but option 1 is still wrong.

    Exclusive locks prevent access to a resource by concurrent transactions

    Read access is not...

    Best Regards,

    Chris Büttner

    February 18, 2010 at 1:08 am

    #1120698

  • RE: Checksums

    I knew I was gonna miss this QOTD as soon as I read the name "Paul Randal" 😀

    Best Regards,

    Chris Büttner

    February 17, 2010 at 3:41 am

    #1119934

  • RE: Concatenation Cursor

    brad.green (2/16/2010)

    In addition to the comment about the missing order by, the result of this is also dependent on the CONCAT_NULL_YIELDS_NULL option. If this option is OFF, the argument...

    Best Regards,

    Chris Büttner

    February 17, 2010 at 3:31 am

    #1119928

  • RE: More Tips for New (and old) DBAs

    Great Article!

    Regarding the "just say no" - I think this is a good general baseline.

    But I also think this problem mostly arises when the service level and / or job...

    Best Regards,

    Chris Büttner

    February 12, 2010 at 5:21 am

    #1117961

  • RE: TRUNCATE

    I wonder why there is no DDL trigger available to capture this of event...

    Best Regards,

    Chris Büttner

    February 5, 2010 at 1:23 am

    #1114225

Viewing 15 posts - 166 through 180 (of 522 total)