70-457 Reviewer #08, Implementing Clustered Instance in SQL Server 2012
This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...
2013-08-01
627 reads
This part of the review is still a part of the topic Maintain Instances and Databases which accounts for 17%...
2013-08-01
627 reads
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,373 reads
I was reading some articles from my favorite influencers in LinkedIn and I came across this one. I was enlightened...
2013-07-30
1,226 reads
For our front office alone, I manage about 15-20 SQL database servers. Add to that other database servers that I...
2013-07-30
1,341 reads
There’s a lot to smile on a cool Monday like this. One, it’s 27C outside here in Singapore, a lot...
2013-07-29
699 reads
Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management...
2013-07-29
693 reads
Let’s say you are a member of the development team. Your team got a new project in the works, so...
2013-07-29
633 reads
I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one...
2013-07-27
533 reads
Scenario You have just completed setting up a new development database server for a new project. After that, everyone in...
2013-07-26 (first published: 2013-07-19)
1,829 reads
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,846 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