CREATE DATABASE [Story]
ON PRIMARY
( NAME = N'Story', FILENAME = N'C:DataStory.mdf',SIZE = 101MB),
FILEGROUP [Line1]
( NAME = N'File1', FILENAME = N'C:Data_.It',SIZE = 102MB),
( NAME =...
2021-10-18 (first published: 2021-09-30)
505 reads
It’s TSQL Tuesday! John Armando McCormack (blog|twitter) is our host this month and he’d like us to share some of ... Continue reading
2021-10-12
36 reads
One of the easiest ways to collect information about table activity is to add a series of audit columns to ... Continue reading
2021-10-11 (first published: 2021-09-28)
507 reads
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of ... Continue reading
2021-10-07
90 reads
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? ... Continue reading
2021-10-05
55 reads
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to run a query or a .sql ... Continue reading
2021-10-04 (first published: 2021-09-21)
624 reads
As with all programming tasks there are a number of ways to do something, this is just one that I ... Continue reading
2021-09-27 (first published: 2021-09-16)
551 reads
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure ... Continue reading
2021-09-22 (first published: 2021-09-14)
441 reads
In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding ... Continue reading
2021-09-17 (first published: 2021-08-31)
336 reads
Last month I had you create a security standards document. This month we are going to document our recovery plan. ... Continue reading
2021-09-15 (first published: 2021-09-02)
255 reads
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
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.
Hello SSC, Has anyone encountered this before??? I have an odd issue that I...
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...
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
exec etl.GettheProduct
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