I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...
2020-08-19 (first published: 2020-08-10)
326 reads
I’ve got Python 3.8 on my machine, and recently I got a note that my pip version was old. I tried to upgrade PIP recently with this command: c:python38python.exe...
2020-08-10
478 reads
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...
2020-08-10
25 reads
Helm is a great tool for deploying applications to Kubernetes. We can bundle up all our yaml files for deployments, services etc. and deploy them to a cluster with...
2020-08-19 (first published: 2020-08-10)
486 reads
About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...
2020-08-10
298 reads
Most of DBA are coming from On-premise Database Servers they know very well How we can manage SQL backup using SQL Server native backup or even using SQL Server...
2020-08-08
48 reads
This is a non-technical post, and my opinion. If you don’t want to read it, please ignore future posts with “Social:” at the start of the title. My nickname...
2020-08-07
34 reads
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is going online due to COVID-19. I’m presenting a new session called “Architecting SQL Server Workloads...
2020-08-07
49 reads
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...
2020-08-07
37 reads
I have now printed over 20,000 ear savers. I hit 20k printed yesterday on Aug 5th, exactly 4 months after starting this project. As of 7PM Eastern today, my...
2020-08-06
14 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...
Telp/Wa 62 8217555651 Jl. Metro Pondok Indah No.60 & 61 UA, RT.4/RW.14, Pd. Pinang,...
Telp/Wa 62 8218200233 Shopping Arcade, The Mansion At Kemang, Jl. Kemang Raya No.3-5, RT.1/RW.7,...
Telp/Wa 62 8218200203 Jl. Jend. Sudirman No.Kav.47, RT.5/RW.4, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta...
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