This is the fourth article of the Machine Learning topic. I have introduced you to the Machine Learning, described the process and the tools. My first idea was that...
2019-08-24 (first published: 2019-08-11)
51 reads
I have delivered a preconf on the biggest conference in Asia. The preconf was about Supervised and Unsupervised Machine Learning with bonus track about Semi-supervised solutions. This was really...
2019-08-21
11 reads
I have just written the fifth article of the Machine Learning topic. !!! This time it is an example of the process – step by step. Do not miss...
2019-08-17
57 reads
Hello #SQLFamily! We are packing for the longest trip this year. Next week we will start in Shanghai, then will move to Bangalore for #DPS10 and the last week...
2019-08-06
18 reads
This is the fifth interview we have done. This time our guest is Aaron Bertrand! Aaron is one of the most community oriented person I know and he really...
2019-08-01
46 reads
I would like to start my first Machine Learning project. But I do not have tools. What should I do? What tools (environments, libraries etc) shoudl I use? I...
2019-07-30
186 reads
New week has started and apart from the usual information from the data world I would like to share one more. The Machine Learning topic published last week has...
2019-07-29
11 reads
A little bit late but it is here! It is Wednesday already and we are preparing for #DPS2019 which will be in August in Bangalore. Meanhwile I received another...
2019-07-24
27 reads
This is the second article in the Machine Learning area. I have explained a bit more about the steps the Machine Learning process is built of. You will be...
2019-07-21
302 reads
This is the fourth interview we have done. This time our guest is Grant Fritchey! Probably you do not know that but Grant has started his career in …...
2019-07-19 (first published: 2019-07-04)
567 reads
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Comments posted to this topic are about the item Never is Not the Policy
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