July Question: If you could pick your manager, what ideal qualities would he or she have?
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,944 reads
Comparing DirectQuery and ROLAP for real-time access
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution...
2012-07-02
1,370 reads
Why Isn’t Everyone Accountable? A Work Conundrum
A pattern I’ve seen over and over again at many different jobs is that some people are not held accountable...
2012-07-02
772 reads
Lost in Translation – Deprecated System Tables – syscacheobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-02
1,059 reads
Speaker Selection for SQLSaturday Orlando-Group #3
So far we’ve selected 8 speakers for SQLSaturday #151 in Orlando this year (see Group #1 and Group #2), today...
2012-07-02
758 reads
Want a Sean-made Precon? You got it!
Sean’s giving a precon at SQL Satrurday 163 this October! Oh yeah, and so are Tim Mitchell and David Stein....
2012-07-02
767 reads
Querying Information from the Plan Cache, Simplified
One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...
2012-07-02
1,502 reads
Guest Post: SQL Server Installation Error by David Postlethwaite
A strange SQL installation error with even a stranger solution
This week I was installing SQL Server 2008 R2 Developer onto...
2012-07-02
1,014 reads
Changing physical locations of all DBs
I got a request this week from an application engineer. The request was to move ALL physical database files from...
2012-07-09 (first published: 2012-07-02)
4,450 reads
New in SQL 2012 (1)
Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:
1. Indirect Checkpoint
Prior to...
2012-07-01
2,148 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
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