Power BI and a Star Schema
I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...
2021-03-05 (first published: 2021-03-01)
1,042 reads
A New Git Default Branch
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint, he had htis neat trick: git config --global init.defaultBranch main Apparently, this is a new...
2021-03-09 (first published: 2021-03-01)
371 reads
Daily Coping 1 Mar 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-03-01
22 reads
Viewing the Statistics Objects Used to Create an Execution Plan
Use trace flag 8666 to view the statistics objects that the optimizer used to generate your execution plan.
2021-03-01
32 reads
A Biography Template for New Presenters
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-02-28
15 reads
A Biography Template for New Presenters
Presenting is difficult, and you already know that. It is also incredibly rewarding and beneficial to your career, but that’s not important for this post. As difficult as it...
2021-03-05 (first published: 2021-02-28)
196 reads
Goal Progress–Feb 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-02-26
16 reads
How to: exec sp_help on temp tables?
Say you have a temp table and you want to see the columns names.
For example, I was trying to convert a query from using a #temp table to a...
2021-03-04 (first published: 2021-02-26)
443 reads
Daily Coping 26 Feb 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-02-26
15 reads
ADF: Querying JSON documents
In my previous blog post I talked about how to read from an XML Webervice and use xpath to query the XML on the expressions side of things. You...
2021-02-26
27 reads
Blogs
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...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
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