Forum Replies Created

Viewing 15 posts - 1 through 15 (of 953 total)

  • Reply To: Getting a List of Names

    Glad I've already had my first cuppa this morning. Nice one...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    December 14, 2023 at 8:39 am

    #4345743

  • Reply To: Delete large number of rows help

    Has the table in question been partitioned (or the clustered index)?

    If so, then swap out each partition to it's staging table, run the deletes/inserts, then swap back in.

    If not, learn...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    October 27, 2023 at 9:59 am

    #4315892

  • Reply To: Interrogate XML columns in table, however element names contain _x0020_ (space)

    I would love to. However, that would basically involve a total redesign of the entire database and it's application. Personally, i would recommend scrapping that platform and starting over... the...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    March 15, 2022 at 7:34 am

    #3999586

  • Reply To: Interrogate XML columns in table, however element names contain _x0020_ (space)

    I finally figured how to resolve the issue - convert the XML fields to NVARCHAR(MAX), Replace the _x0020_ with an underscore, convert back to XML, run the shred using nodes(),...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    March 15, 2022 at 6:38 am

    #3999555

  • Reply To: Interrogate XML columns in table, however element names contain _x0020_ (space)

    Here are a few records drawn from the audit trail table - i needed to mask some columns, due to sensitivity, but the detail is still usable...

    Attachments:
    You must be logged in to view attached files.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    March 14, 2022 at 2:13 pm

    #3999082

  • Reply To: The CTE Scan

    Joseph.caldwell 19590 wrote:

    Why would it read twice?

    the CTE is something like a single use virtual view.

    Given that the final select uses a UNION ALL, it will SELECT from the CTE, then...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    March 16, 2021 at 12:15 pm

    #3858455

  • Reply To: The CTE Scan

    I have found many who firmly believe a CTE actually creates a volatile table in tempdb and then reads from it.

    i cannot figure out where they got that idea from.

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    March 16, 2021 at 10:24 am

    #3858415

  • Reply To: Setting the Legacy Cardinality Estimator

    That is cool; nice question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    March 15, 2021 at 5:30 am

    #3857826

  • Reply To: The ADF Case

    This works really well, too.

    Nice question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    November 23, 2020 at 6:04 am

    #3812879

  • Reply To: Checking the Check Constraint

    Nice, easy one today, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    November 5, 2020 at 6:19 am

    #3804498

  • Reply To: Reseed Locks

    Nice question, thanks Steve.

    Been there, done that - best to run that over a weekend when no-one is around...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    November 2, 2020 at 10:00 am

    #3803462

  • Reply To: Funny code

    Interesting question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    October 29, 2020 at 6:01 am

    #3802337

  • Reply To: Copying an Azure SQL Database with PowerShell

    Nice question thanks Steve.

    i particularly enjoyed the red herrings...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    October 26, 2020 at 3:00 pm

    #3801358

  • Reply To: A calculated column in R

    Nice one, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    September 30, 2020 at 6:04 am

    #3791795

  • Reply To: Backing up to Azure

    Nice one, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

    September 29, 2020 at 5:51 am

    #3791508

Viewing 15 posts - 1 through 15 (of 953 total)