Work with data

Top 5 Facts to Find and Replace SQL Texts in SQL Server with REPLACE Function

Database development, Statements, Work with data

Today’s code editors and word processors come with a search and replace feature. It is...
Read More

SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios

Database development, Statements, Tables, Work with data

The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
Read More

Fundamentals of Managing Datafiles in SQL Server

Database administration, Work with data

Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
Read More

Manage MDF Files in SQL Server 2019

Database administration, Work with data

An SQL Server database contains primary data files, secondary data files (optional), and...
Read More

Make Awesome Lists Yourself, or GitHub as Notebook

Database administration, Work with data

This material was originally posted on Habr.com in Russian. The author permitted it to be translated and published on Codingsight. Perhaps,...
Read More

Your Ultimate Guide to SQL Joins: OUTER JOIN – Part 2

Database development, Tables, Work with data

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...
Read More

How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

Database development, Performance Tuning, Tables, Work with data

We often see poorly written complex SQL queries running against a table or tables in databases....
Read More

Synthetic Data Generation

Database administration, Work with data

Introduction Sooner or later, any information system gets a database, often – more than one. With time, that database gathers very much...
Read More

Your Ultimate Guide to SQL Join: INNER JOIN – Part 1

Database administration, Work with data

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....
Read More

How to Make Sense of SQL Server Geography Data Type

Database administration, Work with data • One Comment

SQL Server Geography data type is unlike other types simply because you don’t use it often....
Read More
Close