Search

Manticore search: a continuation of the Sphinx search engine

September 14, 2020 by Hadi Fadlallah

In this article, we will be talking about Manticore Search, which is an open-source search engine first released in 2017 as a fork of the Sphinx search engine. We will try to describe this search engine briefly, mention some of its differences from the Sphinx search engine, and we will provide a step-by-step guide on how to build full-text indexes from SQL Server databases. Finally, we will show how to connect to the Manticore engine from the SQL Server management studio using a linked server object. In our previously published articles in this series, we talked briefly about the Sphinx search engine and how to create full-text indexes from SQL Server databases.

Building full-text indexes using the Sphinx search engine

August 4, 2020 by Hadi Fadlallah

In the previously published article, Getting started with Sphinx search engine, we talked about the Sphinx search engine and how to install it on the Windows operating system. In this article, we will talk about building full-text indexes using Sphinx. We will be covering seven topics:

Getting started with Sphinx search engine

July 10, 2020 by Hadi Fadlallah

In this article, we will be talking about the Sphinx search engine and how to use it to install it on the Windows operating system.

Different ways to search for objects in SQL databases

June 29, 2020 by Rajendra Gupta

This article explores various ways to search for database objects in SQL database such as tables, stored procedures, functions, and views.

SQL FILESTREAM and SQL Server Full Text search

February 19, 2019 by Rajendra Gupta

In this article, the latest in our series on the SQL FILESTREAM feature, we are going to look at the synergy and interoperability with SQL Server Full Text search, another powerful SQL Server feature

Hands on Full-Text Search in SQL Server

August 25, 2017 by Jefferson Elias

Introduction

In most cases, we will use clustered and non-clustered indexes to help a query go faster, but these kinds of indexes have their own limitations and cannot be used for fast text lookup. For instance, a LIKE operator will lead SQL Server to scan the whole table in order to pick up values that meet the expression next to this operator. This means it won’t be fast in every case, even if an index is created for considered column.

How to mimic a wildcard search on Always Encrypted columns with Entity Framework

March 22, 2017 by Hans Michiels

Introduction

The title of this post should have been “How to implement wildcard search functionality with Always Encrypted, make deterministic encryption safer, and load initial data using SqlBulkInsert”, but as you understand, that’s just too long for a title.

Searching SQL Server made easy – Building the perfect search script

March 9, 2016 by Ed Pollack

The need to search through database schema for specific words or phrases is commonplace for any DBA. The ability to do so quickly, accurately, and completely is critical when developing new features, modifying existing code, or cleaning up the vestiges from an application’s ancient history.

Searching SQL Server made easy – Searching catalog views

March 9, 2016 by Ed Pollack

Searching the SQL Server query plan cache

February 8, 2016 by Ed Pollack

Whenever a query is executed in SQL Server, its execution plan, as well as some useful execution data are placed into the plan cache for future use. This information is a treasure trove of metrics that can allow some very useful insight into your server’s performance and resource consumption. Much of this information would be difficult or impossible to acquire otherwise.

Understanding how to access and use the metadata about query execution will provide us the tools we need to answer questions about our server and gain fascinating performance data. I’ve found myself spending more and more time writing, tweaking, and using queries against the plan cache lately and look forward to sharing these adventures with you!