Yesterday, I had the opportunity, and the privilege, to attend an all-day workshop put on by Bob Ward teaching all about SQL Server 2022 (you can take this too, Bob is presenting it at SQLSaturday Austin and SQL Bits, and there will be more). It was a great day. Bob is an excellent teacher. Even […]
2023-02-11
122 reads
Helping your business get value from a digital transformation can start within your own team or group.
2023-02-08
118 reads
2023-02-06 (first published: 2023-02-04)
263 reads
Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly […]
2023-02-06 (first published: 2023-01-28)
236 reads
When I first started working in technology in the 90s, it was a time of outsourcing lots of work overseas. Many large companies followed the wave of manufacturing in the 70s and 80s by many companies, including lots of semi-conductor manufacturers. I watched as a number of jobs moved overseas, though fortunately not mine. In […]
2023-02-06
161 reads
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
342 reads
2023-02-06 (first published: 2023-02-01)
3,767 reads
Being more senior in a role can be an advantage if you work at using your extra knowledge.
2023-02-03
148 reads
Today Steve encourages everyone to feel welcome in the data professional community.
2023-01-27
122 reads
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
2023-01-25
108 reads
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Comments posted to this topic are about the item Never is Not the Policy
I have added a few indexes to one of my tables in SQL Server 2025:
ALTER TABLE dbo.CustomerContact
ADD CONSTRAINT PK_CustomerContact
PRIMARY KEY (CustomerID);
-- Create index on CustomerEmail
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (CustomerEmail);
CREATE INDEX IX_CustomerContact_CustomerPhone
ON dbo.CustomerContact (phone);
I then do this to disable one index:
alter index IX_CustomerContact_CustomerPhone on dbo.CustomerContact disableI see this when I check the index status:
I decide to rebuild all indexes with this command:
ALTER INDEX ALL ON dbo.CustomerContact rebuildAfter I do this, what will I see for the index status? See possible answers