T-SQL Tuesday #88: My Top WTF Moments
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
576 reads
Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...
2017-03-14
576 reads
One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...
2017-03-13
512 reads
From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...
2017-02-17
585 reads
Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...
2017-02-14
664 reads
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,807 reads
If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...
2017-01-04 (first published: 2016-12-30)
2,213 reads
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
708 reads
Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....
2016-12-13
762 reads
Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing...
2016-10-11
695 reads
It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall...
2016-08-09
643 reads
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
Comments posted to this topic are about the item Comparing Images
Comments posted to this topic are about the item Time to Change Your Team
Comments posted to this topic are about the item A Tidy Database is a...
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