Returning Stuff to Amazon
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,455 reads
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,455 reads
One of things we've tried to do from the beginning is to provide each speaker & volunteer with a good quality...
2008-09-28
1,345 reads
As you've probably noticed via the blog I read a lot; technical, fiction, and non-fiction. Reading can be an expensive...
2008-09-25
1,712 reads
Profiler is a fantastic tool for SQL Server DBAs to enable them to examine how batches and code is submitted to the server. Expert SQL Server trainer, Andy Warren, brings us a new article that exaamines how you can log that data in another SQL Server table for later analysis.
2008-09-25
4,121 reads
EarlierI mused a bit about when and why it makes sense to upgrade to a new laptop. One note I...
2008-09-24
2,022 reads
Several years ago during the first iteration of the Orlando SQL Server Users Group I talked a friend into attending....
2008-09-23
1,827 reads
Mechanical posts are ones that are either auto-generated, or manually input with no real additional work put into them - an example...
2008-09-22
1,029 reads
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking about and I have a short story to support it.
2008-09-22
2,211 reads
I've been using a Dell Latitude for a looong time, probably going back to 2000 or 2001. Decent machine - though...
2008-09-21
781 reads
Most of my posts here are reasonably serious, and really this one is too, but a but of humor mixed in....
2008-09-18
656 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