AI Helpers or Replacements
The future will see more of our data used in machine learning and other AI-like systems. Is that something we want?
2017-04-13
67 reads
Editorials
The Value of Your Personal Data
Today Steve Jones discusses the idea of data value, and what it might mean to you, personally.
2017-04-12
59 reads
By Design
Just because something works, is it prudent to implement a solution knowing there is a chance this design flaw will be stricken from future revs of SQL Server? It depends.
2017-04-10
92 reads
How do you define employee satisfaction?
This article explores aspects of a job that help one feel satisfied at work.
2017-04-10
107 reads
Staging Deployments
This week Steve Jones is asking if you stage your database changes ahead of application changes.
2017-04-07 (first published: 2012-11-30)
229 reads
Dealing with Supervision
Working with someone that micro-managers you or watches your every action can be hard. Steve Jones has a few thoughts.
2017-04-06 (first published: 2013-02-04)
268 reads
How do you go about making a big decision?
This article explores the author's way of making big decisions.
2017-04-04
76 reads
2017-04-03
162 reads
The Ideal Agile Database
The ideal Agile database needs to be secure, recoverable, transactional, resilient, and versatile enough to allow easy migration paths when you need to delegate tasks elsewhere, for scalability. Sounds like a relational database to Phil Factor.
2017-04-03
96 reads
Big Companies are Improving with DevOps
Steve Jones notes that not just the small, startup, agile companies use DevOps. Nor is it just technology companies.
2017-03-29
64 reads
Blogs
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...
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...
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