Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners

Total: 3 Average: 4.7

This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values. Additionally, the readers will get hands-on experience by implementing some simple examples of this function.

We’ll also highlight the importance of T-SQL functions in resolving database analytical problems.

Read More

Mastering the Use of Stoplists With SQL Server Full-Text Search (FTS)

Total: 2 Average: 4.5

Creating and managing stoplists serves as one of the main components responsible for improving the Full-Text Search performance alongside reducing the size of the index. This article aims to help you master the job in-depth and implement multiple strategies to create stoplists on simple but interesting examples.

We’ll also highlight the importance of different methods to generate stoplists and clarify how to choose the most suitable method.

Read More

How to use Stopwords and Stoplist to improve SQL Server Full-Text Search (FTS)

Total: 7 Average: 5

The current article is about Stopwords and Stoplist usage. The aim is to make Full-Text Search more efficient in terms of storage and performance. Additionally, the readers of this article will get a walkthrough of implementing Full-Text Search with Stopwords and Stoplist.

The article also highlights the importance of Stopwords and Stoplist(s) to keep the Full-Text Search precise and avoid noise words.

Read More

Learn to Store and Analyze Documents on Windows File System with SQL Server Semantic Search – Part 1

Total: 1 Average: 5

The article examines storing unstructured data using native windows directory structure and managing it through the SQL Server database. Subsequently, we demonstrate how to perform comparative analysis with the help of Semantic Search in order to get valuable information out of the data. Additionally, you are going to get some hands-on experience of storing and linking documents on Windows File System and using Semantic Search.

Read More

How to Use Semantic Search in SQL Server

Total: 23 Average: 4.5

This article deals with the basics of Semantic Search, including a complete walkthrough of Semantic Search: starting from scratch and finishing with a ready-to-use feature.

Additionally, the readers are going to learn about some of the very useful but not generally known Search features available in SQL Server like Semantic Search, which we’ll demonstrate with some basic examples.

Read More