Today we have a guest editorial where Andy Warren asks you if you know how to ask for things at work. Many IT works struggle to ask for resources, but read on to understand how Andy might help you get more done at your job.
2024-01-29
131 reads
During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to […]
2024-01-27
102 reads
Do you enjoy your workplace or employer? Steve does and has a few thoughts on what that is like for him.
2024-01-26
173 reads
Learning to make decisions and then get work done is important to Steve. Read his thoughts today on many of the decisions software teams need to make.
2024-01-24
185 reads
2024-01-22
192 reads
This week I had the opportunity to join many of the U.S.-based Redgaters in Austin to talk about 2024 plans, hear from the product teams, and have some much-needed fellowship. One thing was particularly clear as I listened to various leaders and product managers – the customer drives everything we do. And I have to […]
2024-01-20
74 reads
How do you determine if you're at the top of your profession? Andy Warren has a few thoughts today.
2024-01-19
136 reads
NoSQL is an option for a database platform and Steve wonders if you can discuss and debate the use of NoSQL for your business partners? Or are you going to learn more? He is.
2024-01-17
267 reads
Today Steve wonders if the technology for storage and data transfers has superseded the need for portable drives.
2024-01-15
154 reads
I really enjoy playing with radios [ed: we know, you won't shut up about it]. Something as simple as checking in to a local net (basically saying hi to a bunch of people on the radio) is fun. However, there's so much more to it. In the last few weeks I've been testing a new […]
2024-01-13
96 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...
Hub Via Wa 628218154374 Alamat Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim.,...
Hub Via Wa 628217555651 Alamat Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo,...
Hub Via Wa:62817825533 Alamat Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa...
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