In a previous article we saw what indexes are. In this article we will see how to find the status of their hash, if you are using, when they were created, when they were updated and if they are missing indexes recommended by SQL Server.… read more
How do we automate the index rebuild process in SQL Server without using a maintenance plan
As we have seen in an earlier article for the easiest way to access data in databases we use indexes and statistics. Indexes are essentially an index that helps us find what we are looking for faster. But as... read more
How to Text Search Documents Stored in Database Table in SQL Server Using Full-Text Index
In SQL Server we have the possibility to store files such as docx, xlsx, XML, etc. in table fields. To search for words in these fields, a full table scan would have to be performed, but there is also the solution of creating... read more
What are Columnstore Indexes and when do we use them in SQL Server
In this article we will analyze the difference between a table that is physically stored via a Clustered Rowstore Index and one that is stored via a Clustered Columnstore Index. What exactly are Columnstore Indexes, when should they be used and what are… read more
How databases are stored and what indexes are
We have seen what a relational database is and that our entities are logical objects called tables. But how are they stored “physically” in an RDBMS (relational database management system)? Tables as objects are stored and… read more