Me an MVP? It Really Happened
Yes, I was named a SQL Server MVP the most recent round of awards. I honestly can’t believe it. It is a great honor to have been recognized for...
2011-10-04
4 reads
Yes, I was named a SQL Server MVP the most recent round of awards. I honestly can’t believe it. It is a great honor to have been recognized for...
2011-10-04
4 reads
We did it! SQLRally happened and, from everything I heard, it was a success! That’s not to say that there...
2011-05-17
840 reads
We did it! SQLRally happened and, from everything I heard, it was a success! That’s not to say that there weren’t some glitches and lessons learned, but we accomplished...
2011-05-17
4 reads
It’s hard to believe, but after months of planning and hard work, PASS SQLRally is next week! I admit that,...
2011-05-02
1,040 reads
It’s hard to believe, but after months of planning and hard work, PASS SQLRally is next week! I admit that, as one of the planners, I may be biased,...
2011-05-02
4 reads
Steve Jones and Andy Warren are at it again. The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new...
2011-04-28
708 reads
Steve Jones and Andy Warren are at it again. The founders of SQLServerCentral, SQLShare, and SQLSaturday have started a new program, The Mentoring Experiment, to try to match professionals...
2011-04-28
5 reads
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the...
2011-04-12
841 reads
There have been lots of blog posts about PASS SQLRally (Bing Search), but there haven’t been a lot recently from the organizers. As today (April 12th) is the last day...
2011-04-12
5 reads
I had the pleasure of attending and presenting at SQLSaturday #71 – Boston on April 2nd. Adam Machanic (Blog|Twitter), Mike Walsh...
2011-04-04
1,130 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
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...
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