SQL Server: Using .NET assemblies (SQLCLR)
SQLCLR is a technology for hosting of the .NET CLR engine inside SQL Server. Adding an assembly can be a lifesaver sometimes, since the limitations of coding in TSQL stored procedures, triggers or functions are a lot and profound.
Modified 6 years and 1 month ago
SQL Server: Weird behavior with CONTAINSTABLE, ISABOUT and weighted terms
I came across the following weird behavior in an ISABOUT query in SQL SERVER, that involves the weight keyword and the final rank of the results. I want to describe this behavior here, just in case someone has a good explanation for it!
Modified 5 years ago