DBA 101: Altering a column
People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly...
2017-02-06 (first published: 2017-02-02)
2,221 reads
People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly...
2017-02-06 (first published: 2017-02-02)
2,221 reads
Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating...
2017-01-05 (first published: 2016-12-30)
3,541 reads
I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.
One...
2016-12-30
777 reads
I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...
2016-12-27
1,302 reads
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
1,998 reads
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,388 reads
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...
2016-12-13
701 reads
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,301 reads
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,700 reads
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
982 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 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
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