Forum Replies Created

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

  • Reply To: Temporary data and Differential Backup size

    My results:

    Processed 5128 pages for database 'test', file 'test' on file 1.

    100 percent processed.

    Processed 3 pages for database 'test', file 'test_log' on file 1.

    BACKUP DATABASE WITH DIFFERENTIAL successfully processed 5131...

    June 17, 2019 at 7:45 am

    #3654351

  • Reply To: Getting the time

    Maybe R language is case sensitive? So, Sys.time() is the correct answer, but it's not in the list.

    May 8, 2019 at 7:42 am

    #3638131

  • RE: The Comprehensive Set

    That's true!

    http://doc.pyschools.com/console

    March 20, 2019 at 3:00 am

    #2024978

  • RE: Done testing identity 2

    Weird thing:
    DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0)
    Returns this message:

    Checking identity information: current identity value 'NULL'.
    DBCC execution completed. If DBCC printed error messages, contact your...

    February 28, 2019 at 2:27 am

    #2023172

  • RE: MOT identity

    Steve Jones - SSC Editor - Monday, February 25, 2019 9:51 PM

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

    February 26, 2019 at 2:02 am

    #2022939

  • RE: Types of MOT indexes

    Very good question

    February 14, 2019 at 9:56 am

    #2022088

  • 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

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