PASS Summit 2013 - Highlight Q&A - Where Will You Be?
PASS SQL Summit time, 2013is in full blown progress. Fantastic keynotes and presentations taking place all day long! For those...
2013-10-16
1,438 reads
PASS SQL Summit time, 2013is in full blown progress. Fantastic keynotes and presentations taking place all day long! For those...
2013-10-16
1,438 reads
Today, October 15, 2013: PASS SUMMIT DAY1
It’s October, and it’s PASS SQL Summit time, 2013! PASS Summit is the world's largest,...
2013-10-15
1,238 reads
So, is this your first time attending PASS Summit? Confused, shy, overwhelmed, and don’t know what to do first? Or...
2013-10-15
1,031 reads
Where does he get all those wonderful toys? In the line made famous by Jack Nicholson’s Joker in the original...
2013-10-08
1,518 reads
Warning, this is just a non-technical anecdotal blog of a silly time-warp incident that happened to me yesterday. Thought it...
2013-09-23
869 reads
Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...
2013-09-17
1,532 reads
Next Meeting: Tue, Sep 17 2013
Take note, the New Jersey SQL Server User Group, led by John Dempsey, will be...
2013-09-11
877 reads
And so, the countdown begins for the super spectacular,
extraordinarily exceptional, amazingly awesome, fabulously fantastic confab
that is known as SQLSaturday
#235 in...
2013-08-11
854 reads
Last time, in Part
I of my page-split mini-series, we began speaking about page
splits, defining what they are, how they occur,...
2013-07-26
13,384 reads
TODAY, JULY 25: the NYC SQL Server User Group is honored to have a visiting SQL Server MVP all the...
2013-07-25
1,224 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