In the world of Microsoft SQL Server , views are a powerful tool for simplifying complex data queries. Simple views offer no real performance gain but are often used to implement simple database queries (I still would prefer App implementations over Database implementations for simple views). But indexed views offer a real performance gain.
Read Blog Post
MSSQL Live Query statistics are a valuable tool for software developers working with Microsoft SQL Server (MSSQL). These statistics provide information about the performance of individual queries, allowing developers to identify and troubleshoot any issues that may be impacting the efficiency of their database.
Read Blog Post
A full-text catalog in Microsoft SQL Server is a specialized storage that is used to store and manage full-text indexes for one or more tables in a database. A full-text index is a special type of index that is used to support fast, full-text searches of large amounts of text data. It enables users to search for words and phrases within a column of text data in a table, and returns rows that contain the search criteria. Full-text indexes can be created on columns of data that are stored in character data types, such as char, varchar, and text.
Read Blog PostBy default, there is currently no Full-Text Search Support in the Docker Images for Microsoft SQL Server 2017 or 2019 by Microsoft. The only option currently available is to create your own Docker Image, which includes Full-Text Search in the form of the MSSQL Agent.
Read Blog PostFor some time now, Microsoft has been providing various MSSQL Server versions for Docker - for Linux and for Windows. This means that spending a few hours to install MSSQL Server on your own PC is a thing of the past and is now available with Docker in a few moments.
Read Blog Post