Forum Replies Created

Viewing 15 posts - 16 through 30 (of 187 total)

  • Reply To: Long Wait(for)s

    Nice simple one today, cheers Steve

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    April 16, 2020 at 2:44 pm

    #3743449

  • Reply To: Get a couple fruits

    got this one wrong, should have known really, but still all my tests returned apple and pear

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    March 17, 2020 at 8:12 am

    #3734914

  • Reply To: Identity Values

    nice and simple one to end the week,

    cheers Steve

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    March 6, 2020 at 8:07 am

    #3731800

  • Reply To: finding Stored Procedure that use a specific table outside database?

    I believe OP was planning on replacing the name with a View but i agree a Synonym is a good way to go

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 24, 2020 at 6:35 pm

    #3728357

  • Reply To: finding Stored Procedure that use a specific table outside database?

    Sorry mate not that im aware of. Object explorer (F7) on the views/procs so you can highlight multiple objects then right click drop and create to new window and do...

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 24, 2020 at 5:33 pm

    #3728309

  • Reply To: finding Stored Procedure that use a specific table outside database?

    Hi There,

    I use the below code to find references to text (in this case a table name) in objects,

    Replace TEXT_TO_FIND with the table name you are looking for,

    It uses dynamic...

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 24, 2020 at 4:31 pm

    #3728268

  • Reply To: DBCC Meaning

    was convinced i knew the answer,

    clicked it

    Incorrect....

    Everyday is a school day 🙂

    Thanks

    Shayn

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 19, 2020 at 12:30 pm

    #3727033

  • Reply To: FlushCache Cleaned Up Buffs

    Hi All,

    I have flagged this with our infrastructure team who seem to think that the storage subsystem was not set up correctly to optimize the use of SQL

    With this and...

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 14, 2020 at 11:53 am

    #3725880

  • Reply To: FlushCache Cleaned Up Buffs

    Hi Sue,

    My apologies for not replying sooner i have been out of the office,

    I will have a look into this and see what i can find,

    Thanks for again for your...

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 10, 2020 at 9:13 am

    #3724285

  • Reply To: FlushCache Cleaned Up Buffs

    Hi Sue,

    Thanks for the link,

    The numbers in my results/errors don't seem too high, at least not in comparison to the ones mentioned in the link, but i may be understanding...

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    February 5, 2020 at 4:05 pm

    #3723365

  • Reply To: Switching Database context in transaction

    Nice and easy one, Cheers Thomas

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    January 23, 2020 at 8:32 am

    #3717649

  • Reply To: CHOOSing a value

    nice question

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    January 6, 2020 at 4:20 pm

    #3712710

  • Reply To: The End of 2019

    nice question

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    December 31, 2019 at 8:31 am

    #3711388

  • Reply To: Preparing Encryption with Trace Flags

    nice question steve, thanks

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    December 27, 2019 at 2:42 pm

    #3710749

  • Reply To: The directory creation time

    nice question and good reminder

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

    December 27, 2019 at 2:32 pm

    #3710745

Viewing 15 posts - 16 through 30 (of 187 total)