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,...

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

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...

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...

• This reply was modified 5 years, 2 months ago by david.edwards 76768.

@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...

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

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

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,...

• This reply was modified 5 years, 11 months ago by david.edwards 76768.

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,...

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:...

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...