Forum Replies Created

Viewing 10 posts - 16 through 26 (of 26 total)

  • Reply To: Transaction Isolation Levels

    That's correct, @grahamwade-69740. As per my understanding, I think the NOLOCK hint is applied to a table executing the query, whereas the READ UNCOMMITTED is at a session-level. Please correct...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 3:00 pm

    #3692404

  • Reply To: Transaction Isolation Levels

    Thanks, @ReportThrall.  It is in my to-do list to compare the performance between different transaction isolations and publish it. I will keep you posted.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 2:58 pm

    #3692402

  • Reply To: Transaction Isolation Levels

    Totally agree with you @Bryant-McClellan

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 2:55 pm

    #3692400

  • Reply To: Transaction Isolation Levels

    Thank you for your comments, @mvdba.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 28, 2019 at 2:53 pm

    #3692399

  • Reply To: Modular ETL Architecture Design in SSIS

    Completely agree with your view @jyoung. The only difference is I don't have a separate environment for posting within my infrastructure. So, after the ETL cleansing in stage, I directly...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 21, 2019 at 3:37 pm

    #3690634

  • Reply To: Modular ETL Architecture Design in SSIS

    Thanks. Yeah, I agree on your point as well. But I personally feel that its easier to manage multiple packages in the master packages instead of creating SQL Agent jobs...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 21, 2019 at 2:40 pm

    #3690610

  • Reply To: A User-Defined Function returns more rows

    Yes, I agree with that.

    For obvious reasons, I won't be able to share the data here, but it is a report, which fetches all the tickets that had been sold...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 14, 2019 at 6:55 pm

    #3688642

  • Reply To: A User-Defined Function returns more rows

    Yes, you're correct. In fact, as a developer, I always aim to write code without using any UDFs in the statements. However, in my scenario, we had a lot of...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 14, 2019 at 6:44 pm

    #3688638

  • Reply To: A User-Defined Function returns more rows

    Thanks a lot for providing your suggestions.

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 14, 2019 at 6:42 pm

    #3688636

  • Reply To: A User-Defined Function returns more rows

    Thank you for your comment.

    Well, I think the example that you have given is valid and holds good for this scenario, however, my business case was a totally different one,...

    Aveek has been working as an Analytics Engineer for the past couple of years now. His main areas of interests is SQL Server, SSIS, and SSAS. On his leisure, he likes to travel and is also an amateur photographer.
    https://twitter.com/avikoleum
    https://www.linkedin.com/in/aveekd22/

    October 14, 2019 at 6:41 pm

    #3688635

Viewing 10 posts - 16 through 26 (of 26 total)