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

425 reads

All authors

Read the latest Blogs

Visit the forum

Question of the Day

Which Table I

I have this code in SQL Server 2022:

CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    SELECT  ProductName
    FROM product;
END;
GO

When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

See possible answers

Managing Change Data Capture T-SQL Tuesday #74

Blogs

Another Change

Using Prompt AI to Help Setup Data Analysis

NVMe vs SCSI: Real-World Performance Testing for SQL Server Workloads on VMware

Forums

Simplifying WHERE Condition with LIKE test on multiple columns

Which Table I

Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform

Question of the Day

Which Table I