Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-06
3,404 reads
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-06
3,404 reads
Managing disk space is an important resposibility of the DBA, and there are many ways to perform this task. In...
2011-01-05
2,088 reads
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-05
3,133 reads
She can dig it!
D Sharon PruittA few posts ago in the plan cache series I discussed the children for the...
2011-01-04
1,211 reads
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2011-01-03
2,280 reads
Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need...
2010-12-31
1,433 reads
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-30
1,727 reads
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise...
2010-12-29
5,713 reads
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting...
2010-12-28
1,371 reads
Before moving on to see anatomy of different types of pages, lets spend some time to understand
The relationship among sys.objects,...
2010-12-27
4,468 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