Meme Monday: SQL Family
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me?
Wow…
Geez Tom, couldn’t you ask a hard question for...
2011-11-07
1,791 reads
Blog Posts
MeMeMe - Meme Monday: What #SQLFamily Means to Me
I've been pretty busy polishing up my SQLInspire NYC talk, when I realized that it's another edition of Meme Monday. The...
2011-11-07
1,701 reads
My First Blog Post!
So here it is then, my first ever Blog post!
I'm not cheating here as I am not officially starting to...
2011-11-07
579 reads
Reliving Basic Training, Sort Of
Recently I had the luxury of a long afternoon lunch at Chipotle on a Sunday afternoon, catching up on some...
2011-11-07
801 reads
Resolving 701 There is insufficient system memory to run this query
In recent past while working on an assignment I have encounter an error 701 There is insufficient system memory to run...
2011-11-07
1,930 reads
Slide Decks for PASS, SQL in the City, and SQL Server Connections
I’ve sent my slide decks to the organizers, but I know they don’t always get posted. So I’m putting a...
2011-11-07
949 reads
SQL Server 2012: New Certifications
As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:
Querying Microsoft...
2011-11-07
3,478 reads
SQL Server A to Z – User-Defined Functions
The alphabet is quickly winding down (so sad). We’re up to the letter U and that stands for User-defined functions.
What...
2011-11-07
1,361 reads
SQL server could not start cannot find object or property (0x80092004)
AdvertisementsSQL server could not start cannot find object or property (0x80092004)
Recently I got a call from my team the users...
2011-11-07
8,301 reads
SQL University: Advanced indexing – Sorting and Grouping
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,701 reads
Blogs
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...
Asynchronous Replication of Snapshots from an ActiveCluster Pod to a Third Array
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
Forums
ALAMAT BCA KCU TEGAL Tlp:08218154374
Hub Via Wa 628218154374 Alamat Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim.,...
ALAMAT BCA KCU SALATIGA Tlp:08217555651
Hub Via Wa 628217555651 Alamat Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo,...
ALAMAT BCA KCU PEKALONGAN Tlp:0817825533
Hub Via Wa:62817825533 Alamat Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa...
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