Getting Previous Row in SSIS Data Flow
There is no native function built in to SSIS to get the previous row in the data flow. But with...
2011-09-29
1,766 reads
Blog Posts
PASS Summit 2011: My Itinerary
Here goes with what I hope to achieve the following week in Seattle, WA Oct 9-15 for my 4th summit.
I...
2011-09-29
1,412 reads
Slides & Samples for my SolidQ Summit Sessions
As I have announced in all of my sessions last week in Budapest at the SolidQ summit,
you can find here...
2011-09-29
1,481 reads
Slides & Samples for my SQLdays Sessions
As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays
conference can find here the
Slides...
2011-09-29
1,413 reads
SQL Bits Training Day
By David Postlethwaite
Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing...
2011-09-29
1,590 reads
SSIS For Each Column in a Data flow
Previously I wrote a blog on how to do a for each loop to look through each col in an...
2011-09-29
1,253 reads
The Two Day Adjustment
I made it to Cambridge and actually feel OK. I wonder how I’ll feel tomorrow, but the two day adjustment...
2011-09-29
810 reads
Change Database Owner
This is post is going to be very simple but it is something I come across ever so often and...
2011-09-28
5,027 reads
Consultants: 1099 or W-2?
As a consultant or contractor, you can sometimes be faced with the decision when taking a new contract of whether...
2011-09-28
1,900 reads
David’s SQLBITS Day 1–The Travel Day
Just had a pleasurable 5 hours watching the Autumn countryside go by on a glorious sunny day (in fact its...
2011-09-28
733 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