A Tidy Database is a Fast Database: Why Index Management Matters
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
Many of you can't choose your team, or even change teams if you want, but from an organizational perspective, it might be the right thing to do. Whether you like it or not.
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
Learn how to get started with PostgreSQL using a container to practice database skills.
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform.
This article shows you how to create an Analysis Services Tabular Model project, import data from World Wide Importers database, create a measure and analyze in Excel.
Starting at 4pm PST on Thursday, November 28th, SQLskills will be offering our lowest prices ever for our signature Blackbelt bundle with more than 158 hours of top-quality training.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted a poll here on the blog and on a few of my social media feeds, and here were the results:
By kleegeek
On October 2nd and 3rd, I took part in an amazing event called AI...
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
Comments posted to this topic are about the item Comparing Images
Comments posted to this topic are about the item Time to Change Your Team
Comments posted to this topic are about the item A Tidy Database is a...
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