8:40 Adding extra syntax instead of functions is one of the worst types of language design because it makes things less abstracted and reusable. How about adding an implicit join of foreign keys, that would be the best and most useful feature ever. You could just access sub fields without specifying a join. It's insane that no SQL dialect has this.
If you're referring to the DATETRUNC function, you can use the WEEK date part and then set any desired weekday as the first day of the week using SET DATEFIRST (the default is Sunday). Also, you can use the ISO_WEEK date part which, internationally, treats Monday as the first day of the week.
![SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed](/img/1.gif)
The DISTINCT feature is amazing!
Yes. Generate series and windowed functions enhancements are the real game changers
Great stuff! Thanks!
8:40 Adding extra syntax instead of functions is one of the worst types of language design because it makes things less abstracted and reusable.
How about adding an implicit join of foreign keys, that would be the best and most useful feature ever. You could just access sub fields without specifying a join. It's insane that no SQL dialect has this.
I wish Microsoft would choose international standards of measurement to be default, and not US-specific start of the week 😂
If you're referring to the DATETRUNC function, you can use the WEEK date part and then set any desired weekday as the first day of the week using SET DATEFIRST (the default is Sunday). Also, you can use the ISO_WEEK date part which, internationally, treats Monday as the first day of the week.