Presentations that are Easy on the Eyes
Today Steve Jones talks presentations, specifically the best way to share information on a projector.
2017-06-02
181 reads
Editorials
Consider the Downside
Steve Jones asks software developers to consider the issues we may have with lax internal security.
2017-06-01
92 reads
DNA for Data Storage
Data storage is something all data professionals need to care about, and today Steve Jones talks about a research project from Microsoft.
2017-05-31
109 reads
2017-05-30
60 reads
2017-05-29
42 reads
The Rate of Change of Data
Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.
2017-05-29
111 reads
Do I Need to Learn Linux and R and Python?
The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.
2017-05-26
869 reads
Audio Attacks
We will start to deal with more and more types of data. Steve Jones worries about the possibility of hacking.
2017-05-25
73 reads
2017-05-24
173 reads
Naming Conventions for the Cloud
Today Steve Jones looks at how you might track the various items you use in the cloud.
2017-05-23
230 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