How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
12 reads
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
12 reads
I decided to check if there is still database mirroring option in MS SQL Server 2014
Wow! It works!
MIrroring is still...
2015-10-08
593 reads
I decided to check if there is still database mirroring option in MS SQL Server 2014Wow! It works!However in the screenshot you see a message that new tables “in...
2015-10-08
8 reads
I decided to check if there is still database mirroring option in MS SQL Server 2014Wow! It works!However in the screenshot you see a message that new tables “in...
2015-10-08
8 reads
I want to share my way to convert a string to Base64 and back. Let me note that presented method...
2015-09-30
1,923 reads
I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important...
2015-09-30
18 reads
I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important...
2015-09-30
12 reads
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was...
2015-09-25
1,296 reads
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...
2015-09-25
8 reads
One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...
2015-09-25
32 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