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?
Tag: T-SQL
Preceding and following, can you use them in one statement?
Testing out if you can use preceding and following in the same windowing function @Microsoft @SQLServer #zekerweten