SQL Server MVP
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
866 reads
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
866 reads
I had an email from a friend recently asking about a licensing question pertaining to Microsoft. It reminded me of...
2008-10-09
534 reads
I've been using a Blackberry Curve for a while and I'm been entirely happy with it. Great phone, great battery...
2008-10-08
527 reads
Recently Tony Davis posted some thoughts (almost a rant) about his opinions of PASS, and there is a great follow...
2008-10-07
676 reads
You can find details about these great free events at www.sqlsaturday.com. It's definitely been interesting watching them grow from afar...
2008-10-06
310 reads
As I mentioned yesterday things went pretty well, but always room for improvement. Here are some notes, if nothing else...
2008-10-06
285 reads
I'm writing this as I wait on a flight back to Orlando after spending yesterday with John Magnabosco and team...
2008-10-05
162 reads
Perhaps you've noticed a few of the blog changes if you visit via the web rather than RSS. One good...
2008-10-03
359 reads
I think everyone struggles with keeping track of things they need to do, and it's all too easy to get...
2008-10-01
473 reads
I don't seem to find the time often, but recently I was able to fit in another visit to the...
2008-09-30
1,373 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