Forum Replies Created

Viewing 15 posts - 91 through 105 (of 123 total)

  • Reply To: How to Make Scalar UDFs Run Faster (SQL Spackle)

    You're welcome. I think your articles, and keeping RBAR in mind, have helped me on my SQL journey over last few years, and improved my set-based approach to weird problems,...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: How to Make Scalar UDFs Run Faster (SQL Spackle)

    "Cracking" (groan) article. One for the briefcase, thank you.

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: compare row data

    Well, that's a co-incidence! I've not been in here for weeks and weeks, just posted a very convoluted post, then I see this post about comparing columns, row by row.

    Looks...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: Business Reasons For Implementing Power BI

    That's almost exactly how I described it to someone the other day - like the old Outlook and Front Page "Express" products.

    SSRS Express 🙂

    Epitomises the current paradox of much modern...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: Business Reasons For Implementing Power BI

    @spencer13015, thank you for your post.

    I have been tasked with getting to grips with PowerBI, it's new and partially available to us now.  I have single-handedly developed a vast range...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: Ordering by Alias

    Ah, I'm not the only one to notice the typo then 🙂

     

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: The Work of the Ancients

    That wouldn't be Axxia by any chance would it? Understand if you don't want to say.

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • Reply To: The Work of the Ancients

    That wouldn't be Axxia by any chance would it? Understand if you don't want to say.

     

    [Edit] this was supposed to be in reply to a post by Dervey from 2015,...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: Code Reviews

    I'm in the enviable(!)(?) position of being the lone DBA for a mid-size law firm, so I cannot get my work properly peer-reviewed. I have to explain what I have done,...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: Highlighting of changeable data using a "colour table"

    Nate the DBA - Tuesday, July 3, 2018 12:41 PM

    Wow... I just wanted to post to say "I feel your pain" to...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: Highlighting of changeable data using a "colour table"

    Jeff Moden - Sunday, July 1, 2018 5:27 AM

    Heh... Just a random thought... With no reflection on the OP, even as few...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: Highlighting of changeable data using a "colour table"

    Thanks Luis, that looks elegant and gives me some additional options I think.

    I will have a fiddle.

    Jonathan, I would use this highlighting with caution and where appropriate:...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: Highlighting of changeable data using a "colour table"

    Luis Cazares - Wednesday, June 27, 2018 10:38 AM

    The main problem I can see is that there's no guarantee that you'll have...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: The Right Connection

    Phil Factor - Thursday, April 19, 2018 2:53 AM

    Maybe we should train our subconscious mind into good habits by treating all servers...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

  • RE: How to store Excel files In SQL Table

    Unfortunately not had the time to thoroughly read and digest the linked document, but I saw very frequent mention of fragmentation being a large factor. With the proliferation of cheap...

    "Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
    — Samuel Johnson
    I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?

Viewing 15 posts - 91 through 105 (of 123 total)