Indexes are very important in any database, and with MongoDB it’s no different. With the use of Indexes, performing queries in MongoDB becomes more efficient. If you had a collection with thousands of documents with no indexes, and then you Continue Reading..
Actually SQL Server by default does not support content search from PDF files. DMV sys.fulltext_document_types tells us the file types that are supported in your SQL Server instance. To read/index PDF files in SQL Server, we need to load a plugin/class Continue Reading..
Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on rules of a particular language such as English or Hindi or Gujarati etc. Full-text queries can include simple words and phrases Continue Reading..
We get little confused, when the word INDEX comes into the picture? We ask so many questions to our-self before creating a non-cluster index, as far as the performance is concern. As we are aware that the non-clustered indexes plays Continue Reading..