Forum Replies Created

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

  • Reply To: slow processing

    There are a few things to unpack here.  From your screenshot, I can't be certain which transaction it's referring to.  However, you can clearly see that there is blocking occurring...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 31, 2023 at 12:57 pm

    #4167535

  • Reply To: Master Data - Hierarchies Creation, Change and Maintenance

    Removed Duplicate

    • This reply was modified 3 years, 2 months ago by Y.B.. Reason: Duplicate Post

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 29, 2023 at 7:25 pm

    #4166825

  • Reply To: Master Data - Hierarchies Creation, Change and Maintenance

    Jason A. Long wrote:

    Jeff Moden wrote:

    Wow.  Thanks Jason.  I seriously had no clue.  Like I said, my aim is to help, not collect accolades for a resume but that comment just made the...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 29, 2023 at 7:21 pm

    #4166824

  • Reply To: Master Data - Hierarchies Creation, Change and Maintenance

    Jason A. Long wrote:

    This, in my opinion, is still the best article about nested sets available anywhere... Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

    1000% this!

    Despite being almost...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 15, 2023 at 6:11 pm

    #4161100

  • Reply To: Decoding Set Options

    Yeah, I have to admit this one was a little confusing.  According to the documentation "Value 4" on the user options table is referring to CURSON_CLOSE_ON_COMMIT.  If you take it...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 15, 2023 at 1:07 pm

    #4160991

  • Reply To: Troubleshooting slow running query

    SQLisAwe5oMe wrote:

    Thanks everyone for the responds....I will start with basics.

    Do you have the link for "first responder toolkit sp_BlitzCache"

    That is part of a package of free tools provided by the...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 9, 2023 at 7:49 pm

    #4159001

  • Reply To: Troubleshooting slow running query

    The question is a little vague so I'm afraid I can only give a broad answer in return.  DEV/Staging environments don't typically have the same amount of data so check...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    March 9, 2023 at 6:47 pm

    #4158978

  • Reply To: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

    isaac.arellano wrote:

    Hi, excellent post, I have taken it and put it into practice, and it works very well for me to redo the whole nested set, But I want to...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    December 28, 2022 at 4:44 am

    #4130913

  • Reply To: CPU Upgrades

    I just recently updated my home desktop.  I thought to myself that I just needed a new CPU to upgrade to Windows 11.  Which as you mentioned required a new...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    December 22, 2022 at 3:55 pm

    #4128983

  • Reply To: Export to Excel - how long does it take

    OMG Jeff, I almost spit out my drink after seeing the "Dashboard" image.  The truth is some will want it in Excel no matter how great the Dashboard is.  It's...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    November 21, 2022 at 3:48 pm

    #4115988

  • Reply To: Db is slow

    Before I had access to monitoring tools I found (and still do) 'sp_WhoIsActive' to be immensely helpful to gain insight as to what is happening right now.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    November 7, 2022 at 7:38 pm

    #4109757

  • Reply To: Building a PC

    I've literally built 100's of them.  One of my first jobs in the IT field was for a College that needed to refresh the PC's in their labs and classrooms. ...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 10, 2022 at 1:16 pm

    #4047512

  • Reply To: Drawbacks of having hundreds of data files per database

    Jeff Moden wrote:

    "Dear Lord, I'm a production DBA... please give me patience because, if you give me strength, I'm going to need bail money to go with it". 😀

    .

    This made my...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 11, 2022 at 7:56 pm

    #4031382

  • Reply To: Is SQL Express enough?

    It's unfortunate that so many people believe SQL Express to be an "inferior" product.  While it has limitations (Size, CPU, Memory), it is often more than enough for some lightweight/stand-alone...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 11, 2022 at 6:12 pm

    #4031326

  • Reply To: T-SQL Pivot Question

    I think many of us here would be happy to provide an example if you provided some DDL we could work from.  However, if you really just want some research...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    May 5, 2022 at 5:34 pm

    #4027540

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