SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
17 reads
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
17 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and stub tests. If you open a stored procedure in...
2015-11-17
6 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
30 reads
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
27 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look sloppy, one of those is unnamed constraints, what you...
2015-11-16
4 reads
Automatically name primary key constraints
There are some things you see when writing t-sql code and schemas that just look sloppy,...
2015-11-16
445 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
26 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
47 reads
I have made some changes to the way MergeUi works and also moved it into a new repository (https://github.com/GoEddie/SSDT-DevPack).
The way...
2015-11-16 (first published: 2015-11-12)
1,670 reads
I have made some changes to the way MergeUi works and also moved it into a new repository (https://github.com/GoEddie/SSDT-DevPack).
The way MergeUi used to work was that it enumerated the...
2015-11-12
3 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