My Surprise MVP Party
Two Fridays ago, Sean and I sat down for our weekly DBAs@Midnight webshow* as usual. Unusually, we were expecting an out-of-town...
2011-01-24
579 reads
SQL Awesomesauce
RTFM365, Week 7
[Commence whine-a-thon, thinly veiled as an introductory paragraph to a blog.]
As I knew it would, it is getting VERY difficult...
2011-01-24
487 reads
Blog Sins
Thoughts come together, and the hybridization of your thoughts give rise to new ideas. Here are the thoughts:
I have this...
2011-01-21
673 reads
Who do you want to see at SQLRally and 24HOP?
I dig democracy: I like all this voting for SQL sessions at events.
Voting is open this week, Jan17 – 23, for...
2011-01-19
615 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,079 reads
T-SQL Tuesday #014 Roundup
Wow…the inagural 2011 T-SQL Tuesday was so big, it lasted a week! A few quick observations, then on to the...
2011-01-18
1,270 reads
RTFM365, Week 6
Just a quick note this week….things are quite crazy right now, and I’m struggling to keep reading on my days...
2011-01-18
434 reads
T-SQL Tuesday: Resolutions
In my invitation to T-SQL Tuesday #014, I picked the topic “Resolutions”, clearly to play on the new year. The...
2011-01-11
750 reads
Top 10 SQL #Awesomesauce for 2010
Here at MidnightDBA.com, we’re all about you! And us! It’s just us, and you. Which is why I’ve put together...
2011-01-10
801 reads
RTFM365, Week 5
I’m trying to plan out this week better, and come at the RTFM readings with a sense of direction an...
2011-01-07
454 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
JSON Has a Cost
Comments posted to this topic are about the item JSON Has a Cost, which...
Question of the Day
Which Result II
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
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