2016-05-13
88 reads
Editorials
Solving Tempdb Issues
A simple change might solve some of those tempdb issues various customers experience.
2016-05-12
198 reads
Use Tools
One of the great things about IT is that we have so many tools to help us do our jobs. We can even build tools as needed. So why don't more IT people take advantage of this?
2016-05-11 (first published: 2012-05-23)
473 reads
A Lifetime of Software
Today Steve Jones wants you to look forward in your career. Do you enjoy working with software and technology? Do you plan on doing this for the rest of your career?
2016-05-10 (first published: 2012-04-27)
273 reads
Don’t Miss Out on an Opportunity to Connect
There are people in our lives that we want to connect with, so why don't we?
2016-05-09
109 reads
The Information Schema and Cross-RDBMS Working
A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.
2016-05-09
75 reads
Work to Live
It's important that you remember to live and enjoy your life as it passes by. Today Steve Jones reminds us that we want to work to live, but also plan to live and plan for the future.
2016-05-06 (first published: 2012-05-02)
440 reads
Promoting Engineers
It seems that often we promote the best technical people into managerial positions, but is that a good idea? Steve Jones notes that a few people think this is a bad idea and there ought to be a technical career path for IT workers.
2016-05-05 (first published: 2012-05-01)
297 reads
What’s in a name?
When a business does not have an agreed set of definitions for their every day terms slow burning chaos ensues.
2016-05-04
118 reads
What Does a DBA Do?
Today we have a guest editorial from Andy Warren as Steve is away. Andy tries to define what a DBA really does in a way that might make sense to others.
2016-05-03
335 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