In this post, the fourth in our series, I want to share an example demonstrating SQL Server 2022’s T-SQL Snapshot Backup feature in a scenario where a database spans...
2025-02-10 (first published: 2025-02-01)
356 reads
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming release focused on AI, analytics, and modern database development, backed by innovations in mission-critical engine...
2024-11-27 (first published: 2024-11-19)
791 reads
Introduction In this post, the third in our series on using T-SQL Snapshot Backup, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server...
2024-09-03
44 reads
Introduction In this post, the second in our series, I will guide you through using the new T-SQL Snapshot Backup feature in SQL Server 2022 to take a snapshot...
2024-09-18 (first published: 2024-09-01)
323 reads
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup times and resource contention. T-SQL Snapshot Backup, a new feature in SQL Server 2022, addresses...
2024-09-01 (first published: 2024-08-31)
168 reads
Introduction Welcome back to the fifth installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, we’re diving into a hands-on demonstration of using...
2024-06-28 (first published: 2024-06-12)
193 reads
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The next course “Certified Kubernetes Administrator: Performing Cluster Version Upgrades” in the updated series is now...
2024-06-12
30 reads
We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The next course “Certified Kubernetes Administrator: Working With Your Cluster” in the updated series is now...
2024-04-28
48 reads
We’re kicking off a major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The second course “Certified Kubernetes Administrator: Using kubeadm to Install a Basic Cluster” in the updated...
2024-03-22 (first published: 2024-03-12)
157 reads
We’re kicking off a major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The first course “Certified Kubernetes Administrator: Kubernetes Foundations” in the updated series is now available on...
2024-01-17
213 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers