What I want to do
# create file local.users.yml
user:
- name: foobar1
email: foobar1@foobar.com
- name: foobar2
email: foobar2@foobar.com
- name: foobar3
email: foobar3@foobar.com
locals {
users_file = "local.users.yml"
users_file_content =...
2020-08-10 (first published: 2020-07-29)
6,263 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing that helps ensure your data is...
2020-08-07 (first published: 2020-07-29)
299 reads
After being selected to present my full day pre-conference session at the Summit, I am very pleased to announce that I will also be presenting my Database Administration Through...
2020-07-29
31 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-29
23 reads
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge Can you write...
2020-07-29
805 reads
Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...
2020-07-29
12 reads
Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...
2020-07-29
14 reads
Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values...
2020-08-10 (first published: 2020-07-29)
586 reads
Azure RBAC is Role-based Access Control it is the gateway for any access (access management of Azure resources) and this service will help you to manage the access and...
2020-07-29
15 reads
(2020-July-29) There is a well known and broadly advertised message from Microsoft that Azure Data Factory (ADF) is a code-free environment to help you to create ...
2020-08-07 (first published: 2020-07-29)
995 reads
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
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