Friday SQL Nugget #1
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like...
2012-01-13
1,443 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
PASS Summit 2012 Evaluation Results
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,735 reads
SQL Saturday #104: Colorado Springs
I’ll be presenting at the Colorado Springs SQL Saturday on January 7th of 2012. The session is called Seven Ways...
2011-12-14
1,935 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.
2011-12-14
6,689 reads
Changes to SQL Server 2012 Execution Plans
I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most...
2011-12-12
10,189 reads
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,704 reads
A DBA is a Data Professional
DBA (Database Administrator) is a Data Professional tasked with managing an organization’s data using some sort of database software, such as Microsoft SQL Server. They are concerned with gathering, storing and presenting data to data consumers, which includes virtually anyone in the modern world.
2011-12-08
1,076 reads
SQL Connections Fall 2011 Speaker Evaluations
In keeping with the past, I’m going to go ahead and post my evals for the two sessions I did...
2011-12-06
1,584 reads
Resolutions: Outcome
Earlier this year, I wrote a post about my upcoming plans for the year in response to a question asked...
2011-12-05
1,602 reads
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,330 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