Forum Replies Created

Viewing 15 posts - 631 through 645 (of 1,034 total)

  • RE: VLFs in Log Files

    cengland0 (1/7/2011)

    WayneS (1/7/2011)

    Exactly. Doing a t-log backup will clear the VLFs (if possible), so that they can be reused. The t-log grows when it's out of VLFs. You should be...

    January 7, 2011 at 12:09 pm

    #1270832

  • RE: VLFs in Log Files

    cengland0 (1/7/2011)

    WayneS (1/7/2011)

    So are you saying that if the log file was created properly, I would only have to backup the transaction log and not shrink it? Not sure...

    January 7, 2011 at 12:07 pm

    #1270830

  • RE: Subtle Line Feed / Carriage Return issue

    stewartc-708166 (12/23/2010)

    par for the course....

    CR was a placemarker character, left over from the old typeset days, which told the typesetter to go to the begining of a line (or the...

    December 23, 2010 at 7:32 am

    #1265936

  • RE: Subtle Line Feed / Carriage Return issue

    Might as well add me to the list of having the right answer and getting it marked wrong.

    A QotD on a bug that has been fixed for years is a...

    December 23, 2010 at 7:28 am

    #1265934

  • RE: SELECT TOP

    Dietmar Weickert (12/21/2010)

    BOL (http://msdn.microsoft.com/en-us/library/ms189463.aspx) states clearly

    If the query has no ORDER BY clause, the order of the rows is arbitrary.

    hence putting "Ann" as the correct answer is simply...

    December 21, 2010 at 9:08 am

    #1265135

  • RE: SELECT TOP

    Always use the top with an ORDER BY clause!

    I got the question correct, but this is the last sentance of the answer's explanation.

    Why?

    Why should I always use TOP with...

    December 21, 2010 at 9:05 am

    #1265134

  • RE: Nested Temporary Tables

    WayneS (12/20/2010)

    SanDroid (12/20/2010)

    WayneS (12/20/2010)

    6. Table variables are the only available choice to pass a table to a procedure.

    I know XML is not realy a table, but it can be...

    December 21, 2010 at 7:22 am

    #1265063

  • RE: Nested Temporary Tables

    SQLkiwi (12/20/2010)

    In practice, I often find that the presence of a temporary object (of sufficient size or complexity to make a table variable a poor choice) an indicator that I...

    December 20, 2010 at 9:28 am

    #1264673

  • RE: Nested Temporary Tables

    SQLkiwi (12/18/2010)

    I am slightly confused as to what is meant by a 'simply named' temporary table in the preceding discussion.

    Strikes me this is a great reason to use table variables...

    December 20, 2010 at 8:09 am

    #1264646

  • RE: NULL Values and Joins

    Carlo Romagnano (12/20/2010)

    philip.cullingworth (12/20/2010)

    da-zero (12/20/2010)

    Your output has 7 rows and the column d contains "three" for the 7th row, so it should be answer D.

    But Answer D is

    7 rows...

    December 20, 2010 at 7:49 am

    #1264633

  • RE: NULL Values and Joins

    The answer has the following text in it.

    7 rows where column d = three

    The wording of the answers were confusing as hell.

    They should be listed as

    7 rows returned, the...

    December 20, 2010 at 7:48 am

    #1264631

  • RE: Nested Temporary Tables

    mtillman-921105 (12/16/2010)

    mtassin (12/16/2010)

    mtillman-921105 (12/16/2010)

    Cliff Jones (12/16/2010)

    A very interesting question but I am not sure the answer is completely correct? Seems like the contents of the temp table would...

    December 16, 2010 at 9:31 am

    #1263542

  • RE: Nested Temporary Tables

    mtillman-921105 (12/16/2010)

    Cliff Jones (12/16/2010)

    A very interesting question but I am not sure the answer is completely correct? Seems like the contents of the temp table would be within...

    December 16, 2010 at 9:11 am

    #1263530

  • RE: Nested Temporary Tables

    Daniel Bowlin (12/16/2010)

    Interesting question, even more interesting explanation. Hmmm. I guess my take away from this question, is don't use temp tables in stored procedures.

    That would be a...

    December 16, 2010 at 8:56 am

    #1263519

  • RE: Hidden Formatting Troubles with STR() (SQL Spackle)

    Jeff Moden (12/15/2010)

    mtassin (12/15/2010)

    I didn't even know STR() existed... when I need to make strings out of numbers I always use cast and convert.

    Thanks a lot Jeff... as I said...

    December 16, 2010 at 7:08 am

    #1263435

Viewing 15 posts - 631 through 645 (of 1,034 total)