SQLSaturday#235 NYC - The Schedule You All Have Been Waiting For!
Late last night in the
Halls of Congress, a grand gathering of planners took place to form that
which we...
2013-07-19 (first published: 2013-07-18)
1,703 reads
Late last night in the
Halls of Congress, a grand gathering of planners took place to form that
which we...
2013-07-19 (first published: 2013-07-18)
1,703 reads
Just a quick word on some local events coming your way in the New Jersey area!
TOMORROW - The NJSQL user...
2013-07-15
956 reads
So, it’s Tuesday and its that time again for T-SQL Tuesday. We’re at the 44th entry which means it’s been...
2013-07-09
1,824 reads
Hey, all!
Today, going on all day, is the Summer Performance Palooza 2013, hosted by the PASS Performance Virtual Chapter. It is...
2013-06-27
1,712 reads
This month, Thursday, June 27, 2013, the NYC SQL User Group be doing something a little different. Instead of a technical presentation,...
2013-06-25
931 reads
SQLSaturday 200 is already looking further away in the rear view mirror, but it was a great event!
Joey D'Antoni, Sebastian...
2013-06-05
956 reads
With less
than two weeks to go until SQLSaturday#200 at 45
Liberty Blvd., Suite 210 Malvern, PA 19355, Malvern, PA, 19355 they're...
2013-05-20
1,768 reads
This month’s rendition of T-SQL Tuesday - #42, is hosted
by SQL MVP, Wendy Pastrick (blog|twitter) , who maintains her blog about Life,...
2013-05-14
1,188 reads
{Start Circus bumper music here} LADIES and GENTLEMEN; SQL SERVER
PROFESSIONALS of ALL AGES, Come one, come all!
Get ready for a...
2013-04-17
1,230 reads
As I was
exploring the twitter verse, I came across a post with the invitation to this
week’s TSQL
Tuesday #41, and immediately...
2013-04-09
2,291 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