Use The Correct Data Type
Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Saying that you should use the...
2016-05-18 (first published: 2016-05-12)
1,991 reads
Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Saying that you should use the...
2016-05-18 (first published: 2016-05-12)
1,991 reads
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run...
2016-05-03
594 reads
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
972 reads
Not all of us are going to use Azure in the same way. That’s just common sense. Therefore, not all...
2016-04-27
1,834 reads
For several years, many of us who were involved with working in Azure from the early days, were concerned that...
2016-04-21
524 reads
If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and...
2016-04-20
482 reads
Blog post #4 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
In SQL Server, in the T-SQL you use to query...
2016-04-19 (first published: 2016-04-12)
3,129 reads
I’ve been getting lots of questions on views lately. Must be something in the water.
Because SQL Server allows you to...
2016-04-05
547 reads
THIS IS NOT AN APRIL FOOL POST!
Seriously.
My Speaker of the Month for April 2016 is Keith Tate (b|t) and his...
2016-04-01
491 reads
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
812 reads
By Brian Kelley
Following the advice in Smart Brevity improves communication.
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
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...
Comments posted to this topic are about the item Your AI Successes
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