Setting up R in SQL 2016 – Avoiding Pitfalls
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.
In this article, see how to created shared functions using C# assemblies in U-SQL.
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.
Am I guilty of over-customising software? Read this and let us know what you think.
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
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