A large part of the success I've had in my career has come from growing my skills, both technical and soft, throughout the years. I've always been driven to learn more and improve my ability to accomplish the tasks I've been assigned. Or those that I've sought out and tackled. A little initiative has been […]
2022-12-23 (first published: 2022-12-17)
391 reads
Would you invest in someone else's career? An actual investment? Would you sell shares in yourself? Steve talks about this today.
2022-12-23 (first published: 2022-11-28)
115 reads
This weekend is Christmas, and likely many of you are not working hard today and will enjoy a long weekend until Tuesday. There are many other holidays at this time of year as well, and I hope you are enjoying the season with loved ones. I want to take a moment to wish everyone a […]
2022-12-23
69 reads
Does your database server need an upgrade? Steve notes that you might learn a bit about the best hardware to ensure a good ROI. Even if you wouldn't make a change for your own desktop machine.
2022-12-21
154 reads
Steve realizes that he doesn't use physical storage anymore for transferring data.
2022-12-19 (first published: 2022-12-16)
175 reads
It's time to look at an instance upgrade for SQL Server Central. Or is it? Steve shares some thoughts about the process and decision making.
2022-12-14
310 reads
Learning to efficiently manage time in a team is hard. Steve has a few ideas today, based on a book.
2022-12-12
176 reads
If you're an experienced, knowledgeable, seasoned (I won't say old), SQL Server data professional, and you choose to use Trace Events (Profiler), more power to you. That's it. That's all I have to say. Do what you think best. I'm never, ever (again), going to second guess you. Further, my apologies for ever having done […]
2022-12-10
225 reads
Is the stuff we do in our off hours truly relaxing or just taking up time?
2022-12-09 (first published: 2017-03-31)
217 reads
2022-12-07 (first published: 2017-03-21)
175 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