Forum Replies Created

Viewing 15 posts - 76 through 90 (of 812 total)

  • RE: Primary keys for an OLTP database

    Eirikur Eiriksson - Thursday, December 27, 2018 4:25 AM

    Thanks for the write up Evgeny!
    😎
    One thought on the test setup, the loop...

    December 27, 2018 at 9:28 am

    #2017426

  • RE: Counting Transactions

    Kendra.Little - Tuesday, December 18, 2018 12:08 AM

    Comments posted to this topic are about the item Counting Transactions
    If you run...

    December 19, 2018 at 2:17 am

    #2016799

  • RE: EmbeddedSplit8K

    Sean Pearce - Thursday, December 6, 2018 6:31 AM

    Yet another split function.....
    While I do appreciate the effort, there are millions of these...

    December 6, 2018 at 6:53 am

    #2015649

  • 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

Viewing 15 posts - 76 through 90 (of 812 total)