2021-08-23
366 reads
Full-Text Search
2021-07-19
426 reads
2021-07-12
519 reads
Meeting business needs with SQL Server full-text search
With the full-text search features in SQL Server, along with several hybrid search methods for comprehensive table scanning, companies can better meet specific business needs.
2009-02-20
2,448 reads
Using full-text search for symbols in SQL Server
Here's how to use full-text search in SQL Server when querying exact SQL expressions that include symbols. Use these steps to search symbols in SQL with these steps.
2008-08-27
3,524 reads
Share Database Knowledge with Office and SQL Server
Longtime SQL Server expert Bill Wunder has written a very interesting article on how to share knowledge among IT staff using the tools you already have in your organization.
2008-08-06
6,687 reads
Full Text Search Noise Words and Thesaurus Configurations
I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.
2008-05-19
2,630 reads
setting full text search using script
This script will help you to understand how to set & use full text search.
2007-10-18
580 reads
2007-01-18
1,055 reads
2006-09-19
994 reads
Blogs
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Forums
PASS Summit Time
Comments posted to this topic are about the item PASS Summit Time
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers