Not SQL: Taking a stand against scammers
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
524 reads
If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...
2017-05-03
524 reads
Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...
2017-04-26 (first published: 2017-04-17)
3,334 reads
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,036 reads
FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...
2017-04-14
490 reads
This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that...
2017-04-11
490 reads
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
499 reads
It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...
2017-03-22
627 reads
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...
2017-03-21 (first published: 2017-03-03)
3,558 reads
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...
2017-03-03
467 reads
If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I...
2017-02-15 (first published: 2017-02-08)
3,376 reads
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...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
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