SQL Server Denali CTP1 Diagnostic Information Queries
Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which...
2011-03-16
995 reads
Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which...
2011-03-16
995 reads
I will be presenting at the Boulder SQL Server User’s Group (BSSUG) on March 15, 2011. My presentation will be...
2011-03-15
515 reads
I have seen a few people get confused about the difference between a mirrored database backup (which is only available...
2011-03-14
1,313 reads
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,512 reads
I will be giving a virtual presentation via LiveMeeting on March 10, 2011. The S3OLV User Group meeting starts at...
2011-03-09
638 reads
Here is a collection of 13 short (less than 10 minutes each) videos about improvements in SQL Server Denali, and...
2011-03-09
1,829 reads
Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL...
2011-03-08
642 reads
Microsoft has released the RTM version of Visual Studio 2010 SP1, which is available on the MSDN Subscribers web site.
Microsoft’s...
2011-03-08
749 reads
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
503 reads
I will be attending and speaking at the Rocky Mountain Tech Trifecta in downtown Denver on March 5, 2011. This...
2011-03-01
491 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