Confidence Intervals for a proportion – using R
What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One...
2017-09-28 (first published: 2017-09-18)
1,333 reads
What is the difference between reading numbers as they are presented, and interpreting them in a mature, deeper way? One...
2017-09-28 (first published: 2017-09-18)
1,333 reads
I am still trying to get up to speed on blogging after a gap. Today I managed to push myself...
2017-09-15 (first published: 2017-09-10)
1,582 reads
I have been trying to get my blogging going again after a gap of two months. It has been incredibly...
2017-09-04
511 reads
The past two months have been very hectic for me. I had an unexpected job offer towards end of July,...
2017-08-28
466 reads
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a...
2017-06-21 (first published: 2017-06-19)
1,962 reads
This test is an extension of the Chi Square test I blogged of earlier. This is applied when we have...
2017-06-12
560 reads
Below is the script to create the table and dataset I used. This is just test data and not copied...
2017-06-12
437 reads
This post is a long overdue second part to the post on Chi Square Test that I did a few months...
2017-05-31 (first published: 2017-05-22)
1,478 reads
This will be year #9 of sql saturdays in Louisville. Every year (starting with 3rd or 4th), it has been...
2017-05-08
435 reads
When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people,...
2017-05-03 (first published: 2017-04-24)
1,921 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