VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing...
2018-03-05
135 reads
Blog Posts
VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing...
2018-03-05
140 reads
VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing a few vsts extensions and using typescript to write...
2018-03-05
10 reads
2018-03-02
531 reads
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018...
2018-03-02
338 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take...
2018-03-02 (first published: 2018-02-18)
6,526 reads
New Built-in Function CONCAT_WS() – SQL Server 2017
In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...
2018-03-02
1,384 reads
Reporting services error: User XXXX does not have required permissions
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
271 reads
SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
282 reads
SQL Server and Evil Greedy Data Types
In a recent post, I talked about SQL Server reads and how the data is stored in pages. One of...
2018-03-02
52 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
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
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
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