How to Improve Database Design to Speed Up SQL Queries
This article examines some basic database design principles that help ensure your queries can execute more quickly.
2023-05-15
9,373 reads
This article examines some basic database design principles that help ensure your queries can execute more quickly.
2023-05-15
9,373 reads
Learn how to build scatter plots in Power BI and use the clustering option to automatically find clusters within the report data for easy visualization.
2022-10-12
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
2022-09-14
When you have multiple clients in your application, do you want one or many databases?
2022-06-08
374 reads
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
2022-04-01
Is a database like a series of micro-services? Steve draws an analogy today.
2021-11-12
186 reads
When we don't have all the information needed to model data, we often use NULL. However, that causes other issues.
2021-04-12
2,757 reads
Learning to be a better database developer can be hard. Today Steve asks how you might suggest someone learn.
2021-01-22
262 reads
Learn how to use Gitflow workflow to meet the needs of developing new database related features and how to deploy these database changes.
2021-01-21
This article covers the relational database system evolution and covers terms used in relational models such as relation, tuple, attribute, domain, schemas, and key.
2021-01-07
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Automating SQL Server Access Review
On one of my database servers, I have a maintenance plan that includes the...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers