Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,143 reads
Blog Posts
SafePeak version 2.1 for SQL Server Performance Acceleration Released!
Our friends at SafePeak has released a Major Update: Introducting SafePeak version 2.1 for SQL Server Performance Acceleration!
This unique caching solution offers...
2011-10-17
1,554 reads
Scaling SQL Server
On Friday, October 14, 2011, I had the pleasure of delivering my new Scaling SQL Server presentation at the PASS...
2011-10-17
805 reads
Self Service BI and PowerPivot
Marco Russo and Alberto Ferrari have written a book called Microsoft PowerPivot for Excel 2010: Give Your Data Meaning that I finally...
2011-10-17
1,236 reads
Simple XML exist performance enhancement
I came across this really simple best practice from BOL for the xml method exist which when used will give...
2011-10-17
1,979 reads
SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,428 reads
SQL University Lesson 3 Page Compression
Lesson 2: Internal Structures, Vardecimal, & Row Compression
Welcome to Lesson 3 on Compression and welcome back Dear Reader. I want...
2011-10-17
1,095 reads
The Demise of Jar Jar
Today we have a guest post from Steve Jones as Brad is on vacation.
Today we have the third question from...
2011-10-17
530 reads
Understanding Kerberos, Part I
A get a lot of questions where I work about Kerberos and how it works for SQL Server, whether we're...
2011-10-17
4,357 reads
PASS Summit, more people and lots of newbies!
Once again I am back at home recovering from another PASS Summit. This year the attendance has exceeded all expectations...
2011-10-16
1,398 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