Forcing Execution Plan
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,135 reads
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,135 reads
We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...
2014-03-31
1,946 reads
There is a way by which we can merge the .trc and .blg files to get a great view as...
2013-10-17 (first published: 2013-10-09)
6,320 reads
INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....
2013-09-29
3,913 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Pench National Park is one of the best places to visit for the first...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
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
exec('SELECT ProductName FROM product;')
END;
GO
exec etl.GettheProduct
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