How to Use Semantic Search in SQL Server

Total: 22 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

Implementing Full-Text Search in SQL Server 2016 for Advanced Users

Total: 18 Average: 3.5

This article tells about advanced methods of Full-Text Search usage for data professionals. It enables better search experience in their day-to-day database analysis.

Additionally, the readers will get beyond basic knowledge of Full-Text Search and its implementation. You will see the importance of advanced searching methodology using Full-Text Search to get quick and reliable results.

Prerequisites

First, let’s go through prerequisites since the article is focused on advanced uses of Full-Text Search.

T-SQL Know-How

The article assumes that to implement the walk-through(s), the readers are familiar with writing and running T-SQL scripts against databases with a basic understanding of SQL Server. Read More

Implementing Full-Text Search in SQL Server 2016 for beginners

Total: 20 Average: 3.6

This article talks about the full-text search and its implementation for the beginners to get started.

Additionally, the readers will know the important things to make the full-text search work properly.

This article also highlights the importance of using Full-Text Search to match text patterns and meet similar sorts of requirements.

About Full-Text Search

Let’s understand the Full-Text Search with the help of definitions.

Simple Definition

Full-Text Search is used to optimally search character-based data for quick answers.

Microsoft Definition

Full-Text Search in SQL Server and Azure SQL Database (cloud version of SQL database) let users and applications run full-text queries against character-based data in SQL Server tables. Read More