Performance Benefits of Adding RAM to a Laptop
I have a pretty nice Dell Latitude E6420 that I am using as a loaner laptop while I wait for...
2011-06-30
1,824 reads
I have a pretty nice Dell Latitude E6420 that I am using as a loaner laptop while I wait for...
2011-06-30
1,824 reads
Version 1.58 of the very useful utility CPU-Z was released on June 24, 2011. Originally (and still) popular for bragging...
2011-06-27
762 reads
I recently bought a new teaching and presentation laptop, which is a Toshiba Portege R835-P55X, which I found at the...
2011-06-21
940 reads
I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL...
2011-06-19
913 reads
I just noticed three very recent new TPC-E Benchmark Submissions that I thought were quite interesting. As I have written...
2011-06-15
939 reads
After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara,...
2011-06-13
837 reads
Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information...
2011-06-02
675 reads
Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...
2011-06-01
1,101 reads
I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...
2011-05-20
783 reads
I will be giving the main presentation at this month’s meeting of the Denver SQL Server User’s Group on May...
2011-05-17
583 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