How I tackle disaster recovery
One of my special interests as an autistic person is understanding mechanical components of a computer, both analog and digital. In the olden days, we had devices known as...
2021-05-26
32 reads
Daily Coping 26 May 2021
I 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...
2021-05-26
24 reads
Daily Coping 25 May 2021
I 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...
2021-05-25
23 reads
What account is xp_cmdshell using?
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. ... Continue reading
2021-05-25
153 reads
The Best of Both Worlds: WordPress.com Managed Hosting
How you can get the total freedom to create without the hassles that come with managing your own website. The open source WordPress project has given the world a...
2021-05-24
43 reads
Daily Coping 24 May 2021
I 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...
2021-05-24
15 reads
Database Fundamentals #30: Create Foreign Keys With T-SQL
You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-05-24
11 reads
Database Fundamentals #30: Create Foreign Keys With T-SQL
You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-06-07 (first published: 2021-05-24)
437 reads
How to Repair a Database in SQL Server Management Studio
As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
27 reads
How to Repair a Database in SQL Server Management Studio
As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
5,847 reads
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Forums
Alamat BCA KCP Summitmas Telp/Wa:0821-8200-203
Hub Cs 08218200203 Summitmas I, Jl. Jend. Sudirman kav 52-53 No.61-62 Lt. Dasar, RT.5/RW.3,...
Alamat BCA KCP Iskandar Muda II Telp:0821-8200-233
Telp/Wa 62 8218200233 Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama Sel., Kec....
Alamat BCA KCP Bona Indah Telp/Wa:0821-8200-233
Hub Cs 08218200233 Plaza Bona Indah Jl. Karang Tengah Raya Blk B/12, RT.1/RW.6, Lb....
Question of the Day
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