SQLInspire NYC - SQLPeople Just Got Even More Inspiring!
is all set for Saturday, November 12, 2011, with only 53 days remaining to this fantastic gathering
of assorted SQL Server,...
2011-09-19
1,608 reads
is all set for Saturday, November 12, 2011, with only 53 days remaining to this fantastic gathering
of assorted SQL Server,...
2011-09-19
1,608 reads
We all have been to various training courses throughout our professional career. Many follow a similar standard curriculum or course...
2011-09-16
916 reads
Hey, everybody! Welcome to T-SQL Tuesday #22! Today's topic is Data Presentation, and the importance of formatting data to the...
2011-09-13
3,840 reads
Happy Monday, ALL! I recently announced that I am hosting an awesome contest this month, sponsored by Safe Peak, that...
2011-09-12
1,297 reads
Read on to register for cool events, win an iPad2, be inspired, participate in t-sql tuesday, and more!
It's been an...
2011-09-09
1,596 reads
SQL Server Performance – September Story Contest 2011
Want to win yourself an iPad2? Well you can! Tell your story, 50/50, refer...
2011-09-07
1,753 reads
Invitation for T-SQL Tuesday #22 – Data Presentation
Whilst I was winding down an eventful day with the family on Labor Day...
2011-09-06
8,613 reads
SQL Server, EarthQuakes and the End…Of DBAs?
What does the advent and integration of VMs, SSDs, and the Cloud mean for...
2011-08-31
2,577 reads
I read Andy Leonard's Blog on Earthquakes and Technology, who thought a helicopter was landing in his back yard (LOL), and inspired...
2011-08-24
1,178 reads
Have you ever danced with Denali in the Pale Moonlight? (Ok, I changed that famous quote from the original Batman...
2011-08-18
2,162 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