Build a Beautiful Site in the WordPress Mobile Apps with Predesigned Page Layouts
We think you'll love the new Starter Page Layouts feature.
2021-02-11
1 reads
We think you'll love the new Starter Page Layouts feature.
2021-02-11
1 reads
Figma — one of the most popular and fastest growing digital design tools today — was recently voted “the most exciting design tool of 2021.” In many organizations, a...
2021-02-09
3 reads
2017-04-18
245 reads
For those of you on the Denver SQL Server User Group e-mail list, you probably heard the news I am...
2017-01-05
335 reads
Can’t make it to the #SQLSummit? I know EXACTLY how you feel. Maybe not at the depths or level of...
2016-10-17
366 reads
I am grateful and thankful I got selected to speak again at Speaker Idol. It has been a crazy and...
2016-10-09
356 reads
To All-
I am truly grateful I have been selected for this unique contest: http://www.dcac.co/your-pass-speaker-idol-2015-top-12-are
Good luck to all of my fellow...
2015-10-13
367 reads
#SQLNewBlogger
Details:
System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the...
2015-05-05 (first published: 2015-04-28)
5,706 reads
#SQLNewBlogger
I can just see people skimming that and doing a knee-jerk reaction, “What a cruel and mean title! You should...
2015-04-22
988 reads
#SQLNewBlogger
Some time ago, my kids asked me what I do for a living. I told them I work with databases.
“What’s...
2015-04-15
602 reads
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...
By Steve Jones
One of the things that I’ve been asked in every operations situation is what...
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