Azure, SQL Server and related stuff. Some Powershell as well.
Blog alert! My colleague recently came to me with a fun challenge: why is their SQL Server Hashbytes conversion not working as expected? After some digging, I discovered significant differences between text data types when converting them. Check out my latest blog post to learn more about this interesting topic. #SQL #datahashing #techtalk #SqlServer #Microsoft
In my previous blogpost (Click here to read) I wrote about a query that just wouldn't go parallel. This sparked some discussion and interest from a few people who were very kind and helpful with their suggestions and even deep dives into the query plans, execution statistics etc. To make one thing very clear, this … Continue reading Why won’t you go parallel, part 2
With an unsatisfying end. Intro So what's up this time. Our client has moved to Azure in classic lift and shift scenario. Well, almost. They've deployed new VM's and installed SQL Server 2019 Standard in nice DTAP setting. The VM's are standard E16-4as-v4 SKU. 4 vcpus and 128 GB memory. The disks are Premium SSD … Continue reading Why won’t you go parallel, a curious case of a stubborn query.
A few days ago, I heard the term table clone for the first time, it's preview release date was to be confirmed and I had no idea what it was about. Two days later, a video emerged where the table clone was explained on a high level. At that point, I started to wonder what … Continue reading Microsoft Fabric: shortcuts and table clones
I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause
This month, I hosted the Tsql2sday where I asked you to write about the most funny things you did with T-Sql. I'll happily admit it was a bit of a cheesy subject but you came out in numbers to write! Thanks for that. Before I dive into the blogs I found, send me a message … Continue reading Tsql2sday #161, the writeup
A few days ago, I heard someone stating that Group By was much quicker than Distinct. Less disk impact, less memory etc.So, I thought I'd find out if it's true or not because I found it interesting. I always thought there was no difference. I tested a single small table and found no difference in … Continue reading Distinct or Group By?
This month, Steve Jones (T) invites us to write about the way dynamic SQL helped us solve a problem. Case For one of our customers, we've had an interesting case. They have multiple schemas in the database and the schema's contain a lot of tables with different use cases. To grant user groups (not individual … Continue reading T-SQL Tuesday 155, Dynamic SQL
Last week, one of my coworkers had a nice case. From a dataset, he needed the third row based on an indicator and a timestamp. That sounded a bit vague so I started out with creating a table that contained some records with the columns he'd have to filter on. CREATE TABLE dbo.demo ( id … Continue reading Fun ROWNUM() case, get n’th row from dataset.
Reitse's blog 