Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
286 reads
User defined functions in SQL server can cause all kinds of performance problems, there are however some tricks that are...
2019-01-18
286 reads
Scripted Simulation of SQL Server Loads
When blogging, presenting or testing an idea, one issue I constantly have is that my...
2019-01-17 (first published: 2019-01-11)
2,328 reads
I know, I know your data could never possibly have duplicates because obviously, you have all the constraints in place...
2019-01-09 (first published: 2019-01-03)
2,990 reads
I’ve done a few posts on Clustered and Non-Clustered indexes before, what I’ve not however covered and something that is...
2019-01-09
242 reads
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
402 reads
Indexing on In Memory OLTP tables is a little different from your traditional on-disk rowstore tables…
In Memory Differences…
There is no...
2018-12-24 (first published: 2018-12-04)
2,901 reads
Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...
2018-12-19 (first published: 2018-12-03)
2,269 reads
Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...
2018-12-14 (first published: 2018-11-29)
3,215 reads
In the interests of curiosity I’m going to take a query that runs a relatively simple aggregation over a large...
2018-12-10
294 reads
Since SQL Server 2014 SP1 we’ve had DMV’s that can support Live Query Statistics (Basically a query plan that gives...
2018-12-06 (first published: 2018-11-24)
3,455 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