Move SQL Server Database Files
Do you need to move one or more of your SQL Server database files? For example, are the […]
Database
SQL Server Error 5123
Are you trying to attach a database to SQL Server Management Studio and getting Error 5123? Are you […]
SQL Server Installation
As of February 2019, the time of this writing, the current version of SQL Server is 2017. There […]
MySQL Introduction
MySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […]
SQL Server Access Methods
As Microsoft says: “Generally, there are different methods for accessing the data in each table. If only a […]
SQL Server Gaps
What are gaps? Gaps and islands are classic challenges in T-SQL that involves a sequence of values. The […]
SQL Server Heap
Preliminary Information A table can be organized one of two ways: heap or B-tree. If a table has […]
SQL Server B-Tree
When you think of B-trees, think “clustered index”. All indexes in SQL Server on disk-based tables are structured […]
SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
SQL Server Internal Data Structures
As opposed to the logical query processing discussed in the post SQL Server Logical Query, we are now […]
SQL Server Top N per Group
The top n per group is a classic task in SQL. One example of this task is “give […]
SQL Server Top N per group row_number Single Table
This post provides a solution to the classic top n per group task where you have a single […]