ACID DatabasesACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee validity even […] April 20, 2020 in Database tagged database / transaction / ACID by Mike
SQL Server Set a Database Offline and OnlineDo you need to run a command in SSMS that sets a database to offline or online. You […] January 11, 2020 in SQL Server tagged off / on by Mike
Move SQL Server Database FilesDo you need to move one or more of your SQL Server database files? For example, are the […] January 11, 2020 in SQL Server tagged database / files / move / mdf / ldf by Mike
SQL Server Error 5123Are you trying to attach a database to SQL Server Management Studio and getting Error 5123? Are you […] February 17, 2019 in SQL Server tagged 5123 / attach / denied / database / error / security / access / SSMS / administrator / run by Mike
SQL Server InstallationAs of February 2019, the time of this writing, the current version of SQL Server is 2017. There […] February 16, 2019 in SQL Server tagged installation / 2017 / server / sql by Mike
MySQL IntroductionMySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, the most […] October 21, 2018 in Database tagged database / sql / MySQL / RDBMS by Mike
SQL Server Access MethodsAs Microsoft says: “Generally, there are different methods for accessing the data in each table. If only a […] April 1, 2018 in SQL Server tagged optimizer / scan / engine / access / query / index / SQL Server Data Structures by Mike
SQL Server GapsWhat are gaps? Gaps and islands are classic challenges in T-SQL that involves a sequence of values. The […] April 1, 2018 in SQL Server tagged sequence / gap / gaps / lead by Mike
SQL Server HeapPreliminary Information A table can be organized one of two ways: heap or B-tree. If a table has […] April 1, 2018 in SQL Server tagged b-tree / table / heap / SQL Server Data Structures by Mike
SQL Server B-TreeWhen you think of B-trees, think “clustered index”. All indexes in SQL Server on disk-based tables are structured […] April 1, 2018 in SQL Server tagged sql / storage / internal / SQL Server Data Structures by Mike
SQL Server Pages and ExtentsThe page is the fundamental unit of data storage in SQL Server. An extent is a collection of […] April 1, 2018 in SQL Server tagged extents / database / pages / sql / internal / SQL Server Data Structures by Mike
SQL Server Internal Data StructuresAs opposed to the logical query processing discussed in the post SQL Server Logical Query, we are now […] April 1, 2018 in SQL Server tagged data structures / query tuning / SQL Server Data Structures by Mike