Forum Replies Created

Viewing 15 posts - 91 through 105 (of 825 total)

  • RE: Indexing Computed Columns

    Jeff Moden - Saturday, November 10, 2018 8:00 AM

    I believe you meant "not" rather than "now".

    However, your first example is also...

    November 14, 2018 at 6:43 am

    #2013442

  • RE: Indexing Computed Columns

    Stewart "Arturius" Campbell - Thursday, November 8, 2018 10:53 PM

    Really interesting question, thanks Steve

    forgot that  the results of this datetime function is...

    November 9, 2018 at 1:54 am

    #2012933

  • RE: Mixed Joins

    ChrisM@Work - Wednesday, November 7, 2018 3:36 AM

    Force the join between B and C to take place first, and you change the...

    November 7, 2018 at 4:32 am

    #2012671

  • RE: Undoing compression

    primitivefuture2006 - Tuesday, November 6, 2018 6:01 AM

    Carlo Romagnano - Tuesday, November 6, 2018 1:18 AM

    November 6, 2018 at 6:13 am

    #2012510

  • RE: Undoing compression

    The return type is VARBINARY(MAX) , so, it should be CASTed to a char type.
    Also, there's an undocumented function UNCOMPRESS.
    select UNCOMPRESS(decompress(COMPRESS('a')))
    Try: it returns the...

    November 6, 2018 at 1:18 am

    #2012491

  • RE: ROLLBACK to a SAVEPOINT

    Ken Hiatt - Wednesday, October 31, 2018 5:05 AM

    I’m confused... what are the 2 transactions that are being counted? And is...

    October 31, 2018 at 7:12 am

    #2011834

  • RE: ROLLBACK to a SAVEPOINT

    Sean Lange - Tuesday, October 30, 2018 7:18 AM

    The part of this that is scary is that it seems to perpetuate the...

    October 31, 2018 at 2:47 am

    #2011800

  • RE: Adding a Column Set

    Interesting!
    Also, you don't need to drop the entire table, you can drop sparse columns and re-add them with the ALTER TABLE command

    CREATE TABLE UserConfig
    (...

    September 18, 2018 at 12:53 am

    #2006081

  • RE: Adding a row to a column set

    Giles Sutcliffe - Tuesday, September 11, 2018 2:20 AM

    Queries as written return no data whatsoever, so none of the answers is correct,...

    September 11, 2018 at 2:55 am

    #2005199

  • RE: Adding a row to a column set

    I've got it right, but the first and second answer seems to be equal!
    Can someone  clearyfy me?

    September 11, 2018 at 1:14 am

    #2005189

  • RE: Drop table in one shot

    Kaye Cahs - Tuesday, July 31, 2018 6:50 AM

    Interesting question, Carlo. Thanks.

    I did not know that I could drop more than one...

    July 31, 2018 at 12:54 pm

    #1999755

  • RE: Restoring without CHECKSUM

    Steve Jones - SSC Editor - Monday, July 23, 2018 11:27 PM

    Comments posted to this topic are about the item Restoring...

    July 24, 2018 at 4:02 am

    #1998737

  • RE: Restore options

    Steve Jones - SSC Editor - Thursday, June 28, 2018 11:14 AM

    ?? When is it a good question? When did I do...

    June 29, 2018 at 1:42 am

    #1995751

  • RE: Restore options

    Steve Jones - SSC Editor - Tuesday, June 26, 2018 3:02 AM

    Points awarded back. I never looked at compression, just randomly choosing...

    June 26, 2018 at 10:11 am

    #1995319

  • RE: Restore options

    From BOL:

    To enable backup checksums in a BACKUP statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option. This is the...

    June 25, 2018 at 4:45 am

    #1995113

Viewing 15 posts - 91 through 105 (of 825 total)