Webcast – Small Changes Can Make a World of Difference
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my...
2014-03-18
441 reads
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my...
2014-03-18
441 reads
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
Among other...
2014-03-05
609 reads
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a...
2014-02-20
4,390 reads
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love...
2014-01-28
709 reads
It’s 2014 now. I hope you had fun in new year’s eve.
2013 was an amazing and intense year. To recap...
2014-01-02
783 reads
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
This tradition was started by Adam...
2013-12-10
1,419 reads
While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter)...
2013-12-09
543 reads
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got...
2013-11-11
767 reads
Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource...
2013-10-09
2,237 reads
Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become...
2013-08-30 (first published: 2013-08-26)
3,830 reads
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item 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