Be Cautious About Invoke-SqlCmd Bug
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
1,992 reads
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
1,992 reads
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
357 reads
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
400 reads
I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high...
2015-10-25
566 reads
This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be...
2015-10-23
6 reads
After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...
2015-10-23
586 reads
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-23 (first published: 2015-10-19)
2,848 reads
It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...
2015-10-23 (first published: 2015-10-19)
4,206 reads
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
667 reads
I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day...
2015-10-23
580 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