Analyzing Tempdb Spills and Usage Across Recursive Queries
This article examines how tempdb is affected by recursive queries, using a few different methods.
2025-05-23
2,090 reads
This article examines how tempdb is affected by recursive queries, using a few different methods.
2025-05-23
2,090 reads
2024-04-24
451 reads
2024-04-10
452 reads
2021-02-11
783 reads
In this article we cover many different questions about the SQL Server TempDB database to give a better understanding of what is and what it is used for.
2020-07-27
2020-06-18
844 reads
2020-06-11
850 reads
2020-05-12
673 reads
2020-04-28
747 reads
In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.
2019-12-19
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
Comments posted to this topic are about the item Your AI Successes
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