dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....
2017-06-28 (first published: 2017-06-19)
1,709 reads
Anthony Nocentino Blog
dbfs – command line access to SQL Server DMVs
With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users. People that aren’t used to Windows and it’s tools....
2017-06-19
16 reads
PowerShell Remoting in Multi-Platform Environments – Use Cases
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In...
2017-06-12
757 reads
PowerShell Remoting in Multi-Platform Environments – Use Cases
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In this post, we’re going to leverage that configuration and...
2017-06-12
4 reads
Speaking at SQL Saturday Pensacola!
I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing...
2017-05-26
348 reads
Speaking at SQL Saturday Pensacola!
I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!
If you don’t know what SQLSaturday is, it’s a...
2017-05-26
16 reads
PowerShell Remoting in Multi-Platform Environments using OpenSSH
So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going...
2017-05-25
541 reads
PowerShell Remoting in Multi-Platform Environments using OpenSSH
So in my last post I told you about how I started my journey on learning PowerShell, let’s keep going down that path together. In this post I’m going...
2017-05-25
17 reads
Why PowerShell?
Why do I use PowerShell?
Well, here’s a little back story…last year I was involved in a Pluralsight Play by Play...
2017-05-09
676 reads
Why PowerShell?
Why do I use PowerShell? Well, here’s a little back story…last year I was involved in a Pluralsight Play by Play with Jason Helmick and Jeffrey Snover for launch of...
2017-05-09
8 reads
Blogs
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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