A columnstore index is a type of data structure that’s used to store, manage and retrieve data that is stored in a columnar-style database. Columnstore indexes work well with read-only queries and large-scale analysis. One of their primary uses is queries Continue Reading..
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..
What is fill factor? Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In SQL Server, the smallest unit is a page, which is made of Page with size Continue Reading..
Checking a column existence in a table is very simple in SQL Server, but you should be careful while doing it on Azure environment. We simply ignore the performance consideration while writing SELECTs against systems tables/views/dmvs etc. Recently a stored proc started 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..
SQLIO is not a part of SQL Server package despite its name, it is a tool provided by Microsoft which can be used to determine the I/O capacity or benchmark a given disk subsystem. Benefit of SQLIO is that, it Continue Reading..
OPTIMIZE FOR is a query hint introduced in SQL Server 2005 version and supported in all editions of SQL Server. This query hint can be applied to all DML operations like SELECT, INSERT, UPDATE, DELETE AND MERGE. The OPTIMIZE FOR 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..