Learn How Vendors Price Their Software
As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me,...
2010-04-09
1,361 reads
As DBAs, we are often put in the position of purchasing software from third-party vendors. If you are like me,...
2010-04-09
1,361 reads
Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...
2010-04-06
649 reads
April will be a busy month for me as I will be speaking seven different times, on seven different topics,...
2010-04-02
445 reads
The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...
2010-04-02
420 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-04-01
482 reads
Excerpted from Brad’s Sure Guide to SQL Server 2008, which is available as a free eBook.
Previous versions of SQL Server...
2010-03-31
2,871 reads
When I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs...
2010-03-31
2,297 reads
The Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type...
2010-03-27
472 reads
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
558 reads
If you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This...
2010-03-18
1,431 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