Boris Baliner


SQLServerCentral Article

SQL 2000 to SQL 2005: Where have all the old features gone?

SQL Server 2005 is out and everyone is moving to test and deploy it. However many people are still managing SQL Server 2000 instances. New author Boris Baliner brings us a few tricks to find that information you are used to from Enterprise Manager.

4 (1)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

35,472 reads

SQLServerCentral Article

Quickly Viewing Available Space

As everyone moves to SQL Server 2005 from SQL Server 2000, there are quite a few pieces of information that have moved and may give you trouble finding. Boris Balinger brings us a followup to his first look at some of those changes with a quick article on how you can get the free space in your database files.

4.67 (3)

You rated this post out of 5. Change rating

2006-06-06

9,339 reads

Blogs

Thoughts on AI Data Infrastructure Field Day #1

By

On October 2nd and 3rd, I took part in an amazing event called AI...

PASS Data Community Summit 2024 Day 3 Keynote

By

It’s been an amazing week here, as well as a long week. I’m tired,...

A New Word: Skidding

By

skidding – v. intr. the practice of making offhand comments that sound sarcastic but...

Read the latest Blogs

Forums

Comparing Images

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Comparing Images

Time to Change Your Team

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Time to Change Your Team

A Tidy Database is a Fast Database: Why Index Management Matters

By Phil Grayson

Comments posted to this topic are about the item A Tidy Database is a...

Visit the forum

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);
GO
I 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