Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function
Today’s code editors and word processors come with a search and replace feature. It is...
SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios
The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
Manage MDF Files in SQL Server 2019
An SQL Server database contains primary data files, secondary data files (optional), and...
Make Awesome Lists Yourself, or GitHub as Notebook
This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps,...
Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2
Outer join is at the center stage today. And this is part 2 of your ultimate guide to SQL joins. If you missed part 1, here’s the...
How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective
We often see poorly written complex SQL queries running against a table or tables in databases....
Synthetic Data Generation
Introduction Sooner or later, any information system gets a database, often – more than one. With time, that database gathers very much...
Your Ultimate Guide to SQL Join: INNER JOIN – Part 1
Inner join, outer join, cross join? What gives? It’s a valid question. I once saw a Visual Basic code with T-SQL codes embedded in it....
How to Make Sense of SQL Server Geography Data Type
SQL Server Geography data type is unlike other types simply because you don’t use it often....
