Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.
2014-10-13
125 reads
This week Steve wants to know if you'd have some issues when analyzing data and you've mistaken correlation for causation.
2014-10-10
184 reads
It seems as though Microsoft might be moving to a Continuous Delivery process for Windows 10. Steve Jones isn't sure that's a good thing, but it is interesting.
2014-10-09
101 reads
Data analysis can save money and resources, but it will certainly transform our world.
2014-10-06
104 reads
2014-10-06
310 reads
The popularity of SQL Server seems to be high, but there might be reasons to be concerned.
2014-10-03
703 reads
Microsoft has released a final service pack for SQL Server 2008 R2, which many of you might want to install.
2014-10-02
222 reads
This editorial was orignally published on Dec 8, 2009. It is being re-run as Steve is on vacation. Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.
2014-10-01 (first published: 2009-12-08)
159 reads
How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.
2014-09-30
277 reads
It's important that you are watching your databases' health to be sure that you can make changes, as well as rollback patches when issues occur.
2014-09-29
225 reads
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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