A really simple bug with SSMS
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
530 reads
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
530 reads
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,731 reads
I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...
2016-09-07
346 reads
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
773 reads
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...
2016-08-25
436 reads
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second...
2016-08-18 (first published: 2016-08-11)
2,150 reads
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there...
2016-08-16
512 reads
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
620 reads
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
905 reads
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,030 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