by XTIVIA | Jun 13, 2023 | Blog, SQL Server
Migrating to SQL Server presents businesses with numerous opportunities to streamline operations, improve performance, and enhance data security. However, the migration process can be complex and challenging, especially for companies with limited experience in...
by Ken Haff | Jun 6, 2023 | Blog, SQL Server
What is Indexing? Indexing is a technique to optimize the selection and sorting of data in a database. An index is a data structure that stores a subset of columns from a table or a view, along with pointers to the corresponding rows. The database can use an index to...
by Ken Haff | May 30, 2023 | Blog, SQL Server
What Are Natively Compiled Stored Procedures? These procedures are a new feature introduced in SQL Server 2014 that allows for faster and more efficient execution of queries and business logic that access memory-optimized tables. Memory-optimized tables are tables...
by XTIVIA | Mar 28, 2023 | Blog, SQL Server
As a technical corporate decision-maker, choosing the right database management system (DBMS) for your organization is crucial to ensuring efficient and effective data management. Microsoft SQL Server is one of the most popular DBMS options on the market today and for...
by Faryl O'Neil | Nov 21, 2022 | Blog, SQL Server
If you’re noticing a significant drop in performance, as well as frequent index fragmentation, you might have an issue with page splits, especially if your fill factor is set to default on all of your indexes. What Are Page Splits? Page splits occur when there...