Is your Team Willing to Take Control?
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community,...
2014-07-08
558 reads
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community,...
2014-07-08
558 reads
In a few short days the newest SQL Saturday event. This one will be on the far West coast of...
2014-07-07
470 reads
In a few short days the newest SQL Saturday event. This one will be on the far West coast of the United States. This marks the first time for...
2014-07-07
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for...
2014-07-03
2 reads
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality...
2014-07-03
1,673 reads
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some...
2014-06-02 (first published: 2014-05-28)
1,866 reads
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too...
2014-05-29 (first published: 2014-05-23)
3,424 reads
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
3 reads
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too would wonder the same thing. That withstanding, it is...
2014-05-23
2 reads
Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them...
2014-05-22 (first published: 2014-05-15)
4,221 reads
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
This book was making its rounds on social media, and the concept seems interesting...
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
Hi, hoping someone can help. We're in the process of migrating to a new...
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