Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
2024-03-15
1,468 reads
2022-06-29
455 reads
2022-03-30
541 reads
As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]
2022-12-26 (first published: 2020-08-03)
20,116 reads
2020-04-23
828 reads
2019-10-28
534 reads
2019-01-18
676 reads
2018-06-26
869 reads
2018-01-18
823 reads
Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.
2017-06-15
3,969 reads
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Prazna is a dedicated NGO for women, committed to advancing gender equality and empowering...
Hello, We recently made the following reservation working with VS2022 combined with the SSIS...
Comments posted to this topic are about the item The Hash Join III
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers