T-SQL for Performance and Accuracy – Vern Rabe: A preconference essential for anyone using SQL Server
SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well? Think...
2018-01-11
407 reads
SQL Saturday Preconference: February 9th, 2018 in Redmond, WA Do you think you write T-SQL queries that perform well? Think...
2018-01-11
407 reads
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...
2017-12-20
354 reads
Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros and...
2017-12-03
421 reads
During the month of April, I will be delivering three full-day Power BI hands-On workshops. Each of these events will...
2017-03-02
354 reads
This is a different spin on the top three vendor rankings visualized in Power BI. According to the placement of...
2017-02-17
806 reads
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts...
2017-01-22
509 reads
This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical...
2017-01-17
675 reads
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...
2016-12-28 (first published: 2016-12-10)
1,542 reads
NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted...
2016-12-16
442 reads
I recently needed to replicate all of the reports on one report server to a different server. I started downloading...
2016-12-04
1,427 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
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
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