SQL Server Diagnostic Information Queries for November 2013
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,154 reads
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,154 reads
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,315 reads
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-09-24
1,180 reads
Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697...
2013-09-12
1,668 reads
Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are...
2013-08-29
1,715 reads
On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes...
2013-08-22
1,570 reads
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC....
2013-08-05
709 reads
The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one...
2013-07-30
1,298 reads
On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download...
2013-07-26
1,107 reads
On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count...
2013-07-23
705 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
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...
Comments posted to this topic are about the item Your AI Successes
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