Interrupt Me, I'm Stagnating
Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.
2015-02-05
208 reads
Editorials
You Better Learn to Work at Scale
We are managing more and more systems and databases all the time. To Steve Jones, that means we must be able to work at scale.
2015-01-29
155 reads
Time for Learning
How do you find time for learning? More importantly, Steve Jones asks if you find time for actual use of your knowledge.
2015-01-27
273 reads
Which Problem Are You Solving?
This week Steve Jones talks a bit about problem solving and how you should approach the issue.
2015-01-26
115 reads
2015-01-23
384 reads
Getting IT Out of the Data Center
Technology shouldn't just be a cost sink in an organization, at least that's what Steve Jones thinks.
2015-01-22
119 reads
R-E-S-P-E-C-T
There's one word that can make a difference in how much you like your job. Steve Jones has a few thoughts today.
2015-01-21
225 reads
Taking Care of Things Today
Steve Jones talks about procrastination today and how you might not want to do that with your SQL Servers.
2015-01-19
116 reads
A Little Empathy
Perspective makes a big difference and Steve Jones looks at how you might change the way you think about clients, customers, and the work you do.
2015-01-15
149 reads
Hadoop and SQL Server
Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.
2015-01-14
689 reads
Blogs
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...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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