SQL Server Count Duplicates
You may have a need to count the number of duplicates in a column. Perhaps you want to […]
SQL Server
Multiple Genres in Genres Column
This post discusses the code for a movie database that has a table with a list of genres […]
Atomicity of First Normal Form
Edgar F. Codd’s definition of First Normal Form (1NF) makes reference to the concept of ‘atomicity’. Codd states […]
T-SQL Parse a String in a Column
Do you have a column in your SQL Server database that contains a list of things separated by […]
Text to SQL Server
While this is part 5 of this series, this will be the most simple example. I will be […]
SQL Server Set a Database Offline and Online
Do you need to run a command in SSMS that sets a database to offline or online. You […]
Move SQL Server Database Files
Do you need to move one or more of your SQL Server database files? For example, are the […]
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 […]
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 […]