TSQL Tuesday – But I was Late
I was late to the game having discovered the Blog Post the day after entries were allowed. Despite that, I...
2010-01-14
825 reads
Jason Brimhall
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
632 reads
Professional Communications
This past week I had the opportunity to have lunch with a vendor at his clients’ site. As a part...
2010-01-10
509 reads
Goals For 2010
Like a lemming in the DBA community, I too am going to post my 2010 goals. I am looking to...
2010-01-08
458 reads
SSC Syndication
Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com. I will be syndicated there and...
2010-01-07
596 reads
Primary Key Discovery
As a part of my DB documentation process for a large database, I needed a method to quickly show me...
2010-01-05
696 reads
Users Group Participation
I have been pondering over my local PASS chapter and participation. And more specifically about why I should participate, and...
2010-01-04
984 reads
2009-12-21
5,084 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
Does SSRS Report with Stored Procedure execute SQL string?
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
SQL Server Constrained Delegation
Hi, hoping someone can help. We're in the process of migrating to a new...
Question of the Day
Comparing Images
I am building an ETL process between these tables in SQL Server 2022 set to 160 compatibility level:
CREATE TABLE Image_Staging ( imageid INT NOT NULL CONSTRAINT Image_StagingPK PRIMARY KEY , imagestatus TINYINT , imagebinary IMAGE); GO CREATE TABLE Images ( imageid INT NOT NULL CONSTRAINT ImagesPK PRIMARY KEY , imagestatus TINYINT , imagemodified DATETIME , imagebinary IMAGE); GOI want to run this query to check if the images already loaded exist. This will help me decide if I need to insert or update an image. What happens with this query?
SELECT i.imageid
FROM
dbo.Image_Staging AS ist
INNER JOIN dbo.Images AS i
ON ist.imagebinary = i.imagebinary; See possible answers