Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 3,348 total)

  • RE: Database Size

    Lynn Pettis (1/21/2010)


    david.wright-948385 (1/21/2010)


    Luck then!

    Nope.

    Yes. Luck, because your server apparently has a model database the same size as that of the question author.

  • RE: Database Size

    WayneS (1/21/2010)


    stewartc-708166 (1/20/2010)


    Beg to differ

    when creating a new SQL2008 db, the mdf defaults to 3MB and the ldf to 1MB.

    On my SQL2008 (Developer Edition, x64), the modeldev.mdf is 2MB and...

  • RE: Database Size

    vk-kirov (1/21/2010)


    Hugo Kornelis (1/21/2010)


    The documentation on CREATE DATABASE is here: http://technet.microsoft.com/en-us/library/ms176061.aspx.

    The default log file size is only given in one of the examples (unless I overlooked something)

    It is given in...

  • RE: Database Size

    Since the author of the question didn't even bother to supply a reference for his (or her?) claims, I did his homework for him. The documentation on CREATE DATABASE is...

  • RE: Indexes in SQL Server 2005

    Tony Davis (1/19/2010)


    Apologies to all -- I've now made a correction to the answers so that it applies correctly to SQL Server 2005.

    Best,

    Tony.

    No, Tony. You haven't. 🙂

    SQL Server 2005 allows...

  • RE: Indexes in SQL Server 2005

    vk-kirov (1/19/2010)


    Hugo Kornelis (1/19/2010)


    For SQL Server 2008:

    Up to 1 clustered index, up to 999 nonclustered indexes, and up to 999 XML indexes (http://msdn.microsoft.com/en-us/library/ms143432.aspx), plus a number of full-text indexes and...

  • RE: Indexes in SQL Server 2005

    I chose an incorrect answer so I could get the llink to this discussion. And then, I was even rewarded with a point.

    To add to the others, the correct answer...

  • RE: Temporary objects

    Wow, I never knew I had that kind of influence on you, Steve.

    Too bad I'm not allowed to run for president, as I'd be sure of at least one vote...

  • RE: Temporary objects

    tilew-948340 (1/2/2010)


    I am sorry, but I am this poor little new one that is trying to understand SQLserver and, to this question, I do not understand the answer. The...

  • RE: Temporary objects

    setiv (1/2/2010)


    Where I can search documents about undocumented ability ???

    If a feature is undocumented, then you generally will not find any documents about it easily - that's exactly what makes...

  • RE: Temporary objects

    An interesting QOD, educating people about some little-known features. But:

    1) Why 3 points? It's not a hard question at all; everyone who knows about global temp objects (which SHOULD be...

  • RE: Wild Join Question

    Carleton (12/23/2009)


    If you are unsure if the field contains a wildcard character when joining using the LIKE operator, you can avoid false positive results by observing this tip:

    But what is...

  • RE: How long is a NULL?

    What compatibility level are you using?

    SELECT compatibility_level

    FROM sys.databases

    WHERE name = DB_NAME();

  • RE: How long is a NULL?

    vk-kirov (12/12/2009)


    Hugo Kornelis

    Thank you for explanation. Could you also explain why "under SQL Server 2000, the result is '1234' regardless of the number of NULLs appended"?

    Thanks!

    First, please be aware that...

  • RE: How long is a NULL?

    Arto ahlstedt (12/10/2009)


    the NULL that is appended somehow contributes to the total length of the expression with an effective length of 1.

    Got to love the "somehow"...

    Since NULL can be of...

Viewing 15 posts - 2,941 through 2,955 (of 3,348 total)