by Ken Haff | Jun 27, 2023 | Blog, SQL Server
What is the HierarchyID Data Type? Hierarchical data is a common type of data that represents the relationships between entities in a tree-like structure. For example, you may have hierarchical data for your organizational structure, where each employee has a manager...
by Ken Haff | Jun 20, 2023 | Blog, SQL Server
What Are Columnstore Indexes? A columnstore index is a type of index that organizes data by columns instead of rows. This means that each table column is stored separately, and each value in a column is stored next to other values from the same column. This has...
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 Ken Haff | Sep 13, 2022 | Blog, SQL Server
Multi-GHz processors need maximum memory bandwidth to reach their full potential.SQL Server needs maximum memory bandwidth to reach its full potential. They need to access memory as fast and with as much throughput as possible. A bottleneck develops when processors...
by Ken Haff | Sep 6, 2022 | Blog, SQL Server
A properly designed virtualized SQL Server instance running in a VM with Windows Server (or Linux), using vSphere is crucial to the successful implementation of enterprise applications. One main difference between designing for performance of critical databases and...