Or, how SQL Server behaved differently than I expected but managed to process quite a lot of rows before giving up. Let's begin We have a customer that would like to see the actual value of their stock in a table. They buy their stock at different times and at different prices. Calculating the stock … Continue reading SQL Server Common Table Expressions, a tale.
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.
About two weeks ago I had the immense pleasure of speaking in Berlin for the first time. Now, I'm used to regular events like data saturday's and SQL Bits or dataMinds Connect as outliers because they're larger and different events. But speaking at this one is on a whole different level. As you might gather … Continue reading Speaking experiences at Data Moshpit (Berlin, Germany)
In a blog from a few weeks ago, I wrote about getting data from your on-prem SQL Server into Fabric. At the time, the only option for a copy dataflow was using a direct connection over the internet. It still is, but now you can also use the PowerBI Data Gateway to get data from … Continue reading Getting on-premises data into Microsoft Fabric using the data gateway
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
In my previous blogs, I've written about Fabric and all the cool things it can do. Thing is, my load tests were based on files. Either CSV or Delta. But in reality, a lot of data comes from an on-premises database server. In reality, you might connect to a SQL 2008 instance or maybe even … Continue reading Microsoft Fabric, connect to your on-premises SQL Server
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
This month Deepthi Goguri invites us (the community) to write about two topics: our favourite new feature of SQL Server 2022 and your new years resolutions. You can find her blog here, her LinkedIn profile here and she's also on Twitter here. Favourite new SQL Server 2022 feature Most of my work is in data … Continue reading T-SQL Tuesday #159 – What’s Your New Favourite Feature?
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?
Reitse's blog 