Last Backup Times per Database and Backup Type
This script displays the last date and time of each backup type for each database.
It’s useful when you need to...
2014-02-26
503 reads
Superman
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let’s say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
1,187 reads
How to Load Data from Excel in SSIS – 32-bit vs. 64-bit
Let's say you are developing an SSIS package on your dev box to load data from an Excel file to...
2014-02-25
3,659 reads
SSIS Appetizer
Madeira’s excellent course on SQL Server Integration Services starts in March, but you can get a head start here! Take...
2014-02-09
267 reads
Forty Things You Didn’t Know About SQL Server
Last week I delivered a seminar at the Expert Days 2013 event by the name of 40 Things You Didn’t...
2013-12-16
587 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
436 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
415 reads
PASS Summit 2013 – Day 4: SQLskills Day
This is my fourth day in the PASS Summit. I have already written about my first, second and third days.
The...
2013-10-18
477 reads
PASS Summit 2013 – Day 4: SQLskills Day
This is my fourth day in the PASS Summit. I have already written about my first, second and third days.
The...
2013-10-18
509 reads
PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it’s my third day here. I have already...
2013-10-17
389 reads
Blogs
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Using Prompt AI to Help Setup Data Analysis
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
NVMe vs PVSCSI: Real-World Performance Testing for SQL Server Workloads on VMware
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Forums
Simplifying WHERE Condition with LIKE test on multiple columns
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Which Table I
Comments posted to this topic are about the item Which Table I
Using Python notebooks to save money in Fabric: The Fabric Modern Data Platform
Comments posted to this topic are about the item Using Python notebooks to save...
Question of the Day
Which Table I
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