My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

Managing Change Data Capture T-SQL Tuesday #74

by James-Anderson-The-Database-Avenger

The Database Avenger

T-SQL Tuesday is here again. This month the host is Robert Davis (b | t)
The topic for T-SQL Tuesday #74 is...

2016-01-12

380 reads

All authors

Read the latest Blogs

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code?

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID 
                       FROM Sales.Customer AS C
   WHERE soh.CurrencyRateID = 1
   ORDER BY c.ModifiedDate)

See possible answers

Managing Change Data Capture T-SQL Tuesday #74

Blogs

Big Queries, Big Money

A New Word: Fardle-dun

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

Forums

Which selection criteria is more efficient.

Trigger After Update to Update the Updated Table

The Pervasive Nature of Open Source

Question of the Day

Subqueries II