Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques
It is with an incredible joy and gratitude that I am able to share that I will be delivering a...
2017-06-13
533 reads
It is with an incredible joy and gratitude that I am able to share that I will be delivering a...
2017-06-13
533 reads
This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically...
2017-06-03
1,204 reads
Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
One of the most important and recurring...
2017-05-30
919 reads
Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
For a very long time I was...
2017-05-27
767 reads
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog...
2017-04-23
2,065 reads
Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is a logical continuation...
2017-04-22
548 reads
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
431 reads
Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In SQL Server 2014 we have received...
2017-04-03
435 reads
I am glad to announce thatTuga IT 2017 Tickets are finally on sale!
Wait a second, you might think – on sale?...
2017-04-03
338 reads
Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...
2017-04-01
404 reads
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.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
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