Hot Skills
What are the hot skills for 2011? Steve Jones talks about one that you might not have thought about.
2010-09-28
702 reads
Editorials
Can Wives Shorten Work Hours?
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
2010-09-27
265 reads
SQL Server's implementation of Window Functions
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
2010-09-27
798 reads
Great Service – All About Attitude
today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.
2010-09-24
144 reads
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
2010-09-23
67 reads
What Do We Need in SQL Server?
Steve Jones asks us today about what we might like to see in the next few versions of SQL Server.
2010-09-22
287 reads
NoSQL Is Not Everywhere
NoSQL has been getting a lot of press in the last year, but it's not necessarily the best platform or solution for you. Steve Jones comments on NoSQL and alternative platforms.
2010-09-21
381 reads
Big Data and SQL
Today Steve Jones talks about how some companies find efficiencies by training employees to use SQL. Perhaps that's a good idea for all developers.
2010-09-20
259 reads
The Cloud is Nothing Special
This week Steve talks about cloud computing, and the fact that a lot of what the cloud does is no big deal. But it can be helpful to IT professionals.
2010-09-20
287 reads
We Are Not Alone
Today we have a guest editorial from Robert Pearl that talks about the SQL Server community, and how you can get involved.
2010-09-16
143 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Question of the Day
Rebuilding All Indexes
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