Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
604 reads
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
604 reads
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
525 reads
Ok so I know a statement like that will whip some of you into a frenzy, but it’s true. No...
2010-02-21
530 reads
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
345 reads
There are a large number of Member functions in MDX that do everything from returning ancestry of a member to...
2010-02-21
1,686 reads
When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show...
2010-02-21
2,879 reads
When configuring measures in SSAS, you want to make sure you address a few important properties. They are show in...
2010-02-21
1,099 reads
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
524 reads
Recently, I was working with a client we were working on a calculated measure using the aggregate function to rollup...
2010-02-21
672 reads
One of the most aggravating things when work with the SSIS expression language is when you have to combine file...
2010-02-20
2,283 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