2024-11-13
523 reads
2024-11-13
523 reads
2023-08-04
460 reads
Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.
2021-12-27
Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.
2021-09-01
In this example we will join two CSV files with a common column using SQL Server.
2017-01-23
7,401 reads
You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.
2013-04-08
6,542 reads
2012-02-20
2,394 reads
2009-12-07 (first published: 2009-11-12)
3,078 reads
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
We have created a parent table, child table & Audit log table in SQL...
Comments posted to this topic are about the item Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers