SQL Server 2008 R2 Update for Developers Training Kit
It is a good news for developers! Microsoft published the Training Kit for SQL Server 2008 R2.
The content of...
2010-02-05
593 reads
Dukagjin Maloku
- Interests: Database Admin & BI
Azure platform CTP accounts are about to expire?
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
388 reads
SQL Server 2008 R2 - official date
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...
2010-01-21
446 reads
Windows Azure Platform Training Kit
Everyone interesting for Windows Azure Platform Training Kit - December Update, can find it from Microsoft location here.
There are lot of...
2010-01-20
959 reads
GodMode - in Windows 7
It's very interesting if you create new folder with name:
GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}
Try it and you will find a lot of stuff there...
2010-01-10
519 reads
Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
2009-12-29
2,258 reads
Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
2009-12-28
1,371 reads
SQL Profiler ...Error ...Click OK to terminate program
Hi to everyone! I decide to write it in my blog here about this problem because really don't have any...
2009-08-27
1,302 reads
ALSSUG...soon!
Yes, ALbanian SQL Server User Group will start soon with first meeting and registering the new users. So we will...
2009-06-17
505 reads
Tech Ed 2009: Best of Tech Ed Winners Announced
The best of Tech Ed in Los Ageles award winners were selected from Windows IT Pro and SQL Server Magazine,...
2009-05-15
498 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