July SSSOLV UG Meeting
This is really late notice – apologies in advance.
We will be holding the LV UG meeting July 8th at the same...
2010-07-07
560 reads
Jason Brimhall
SQL 2008 DTS
It’s a Bird…
No, not really. It’s just Windows 7. I have recently upgraded to Windows 7. I took the roundabout...
2010-07-07
3,411 reads
Q2 Goal Review
As we close out the Second Quarter of 2010 it is time to review progress made on the Goals I...
2010-07-06
517 reads
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I...
2010-06-22
754 reads
Who2 Article Published
I just had my second article published on June 14, 2010 at SQLServerCentral. I will be posting a follow-up to...
2010-06-22
985 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
464 reads
What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
13,513 reads
June S3OLV Wrapup
Last night we had our monthly Chapter User group meeting in affiliation with PASS. Honestly, the experience was quite humbling...
2010-06-11
579 reads
2010-06-10
3,922 reads
Data Compression
We have come to that time of month again – blog party. This time, the party is hosted by Jorge Segarra...
2010-06-08
1,025 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
Does SSRS Report with Stored Procedure execute SQL string?
I declare @Where based on the input parameter in the stored procedure. Set @SQL...
SQL Server Constrained Delegation
Hi, hoping someone can help. We're in the process of migrating to a new...
Question of the Day
Comparing Images
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