Announcing Preview Release of MOSL
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
458 reads
The MOSL – Memory Optimised Scripts Library has finally received a first public preview release – the version 0.2.0!
This version introduces the...
2016-11-08
458 reads
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0!
This release is focusing...
2016-11-07 (first published: 2016-11-01)
1,010 reads
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
387 reads
Continuation from the previous 88 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to dedicate this blog...
2016-10-25
522 reads
Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...
2016-10-22
588 reads
Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...
2016-10-10
502 reads
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...
2016-10-05
536 reads
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...
2016-09-23
459 reads
Right now one of the hottest topics around the world is the cloud and the successful methods for the migration...
2016-09-18
695 reads
I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on...
2016-09-13
527 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
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