White Paper Wednesday – Data-tier Applications in SQL Server 2008 R2
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
397 reads
Hey folks,
It’s white paper Wednesday again and this week Data-tier Applications in SQL Server 2008 R2 by Alan Brewer, Roger...
2010-08-12
397 reads
Hey folks,
It’s white paper Wednesday and this week we’re looking at High Availability with SQL Server 2008 by Paul...
2010-08-11
212 reads
Hey folks - Dont 'forget to check out SQL Lunch today. I'm hosting Mr. Andy Leonard! Always exciting and cool information.....
2010-08-09
393 reads
With everyone geared up for SQL Cruise I’m surprised we can air this video but since we kicked it off...
2010-08-07
201 reads
Ok folks, the video from SQL Saturday 40 is finally up. Thanks to the sponsors who helped foot the bill...
2010-08-07
270 reads
This post is the first in a new weekly series meant to give my readers some insight into my week....
2010-08-07
342 reads
In life, many times we get confused by symbols or indicators that we make assumptions about. You know what they...
2010-08-04
182 reads
Today's motivation is that you had nothing to do with this. IF this Pilot had the equivalent of a community...
2010-08-04
183 reads
Goor Morning folks !
It's time for another motivational Monday. Today I want to remind you to be careful about biting...
2010-08-04
483 reads
This week it's all about speed. Many thing in life are drive n by how fast we can get them...
2010-08-04
190 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