The world of databases keeps growing, and the pressure to extract meaningful insights from that data increases just as fast. If you work with data, you know that SQL...
2024-05-15 (first published: 2024-05-01)
1,228 reads
Often times when working with a client, I’ll run into issues or get emails from a client with a message like the following: A connection was successfully established with...
2024-05-14
33 reads
In information security (INFOSEC), there several foundational concepts and principles. One of the ones that’s introduced almost immediately is called the CIA triad or the Information Security Triad. While...
2024-05-13 (first published: 2024-04-26)
257 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Kevin Feasel
(blog | twitter) asks us about job interview questions.
What is your...
2024-05-13
32 reads
Have you ever wanted to filter a visual by selecting a range of values for a measure? You may have found that you cannot populate a slicer with a...
2024-05-13 (first published: 2024-05-01)
334 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most valuable asset: their information. But basic SQL knowledge won't get you far when it's time...
2024-05-11
91 reads
ioia – n.the wish that you could see statistics overlaid on every person you encounter – checking the signal strength of their compatibility, a measure of their trustworthiness. I...
2024-05-10
45 reads
In a previous blog post we went through how to build a Docker container image from a remote (Github) repository. Here we’re going to expand on that by actually...
2024-05-10 (first published: 2024-04-25)
397 reads
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and Developers has been a subject of intrigue, debate, and occasional drama. Do they collaborate harmoniously...
2024-05-10 (first published: 2024-04-29)
322 reads
As I look at the state of information technology today, I see one constant: rapid change. We all see it. While this is the type of post I would...
2024-05-08 (first published: 2024-04-22)
195 reads
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
When I run my query from DW, which uses a linked server, it times...
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
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