SQL Saturday NYC Update #3
SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...
2015-01-09
470 reads
Blog Posts
The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
782 reads
T-SQL script to find the growth size of database files
Below query can be used to see the growth size of database files.
DECLARE @filename NVARCHAR(1000);
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn...
2015-01-09
1,548 reads
T-SQL script to find the highly populated tables in database
Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we...
2015-01-09
1,406 reads
"OR" pattern causing indexing scans in parameter based queries
#Tl;dr article (time constraints prevented me from reworking significantly)
An article on SQL-Server-pro was forwarded over to me to research by...
2015-01-08 (first published: 2015-01-05)
8,560 reads
(Ctrl+E) was pressed. Waiting for the second key of chord…
I first came across the error “(Ctrl+E) was pressed. Waiting for the second key of chord…” last year, these weird errors...
2015-01-08
2,161 reads
Better late than never…
Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...
2015-01-08
640 reads
Building Connection Strings
I ran across a great article on Connection Strings from my good friend, Allen White (b, t, c), recently. Quite...
2015-01-08
1,043 reads
Enabling Portable Git in Node.js command prompt on Windows
GitHub for Windows doesn't put Git in the PATH by default. If you'd like your Node.js command prompt to have...
2015-01-08
1,333 reads
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-08 (first published: 2015-01-05)
6,256 reads
Blogs
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...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Rebuilding All Indexes
Comments posted to this topic are about the item Rebuilding All Indexes
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_CustomerEmail
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.CustomerContactAfter I do this, what will I see for the index status? See possible answers