T-SQL Tuesday: A Day in the Life of a BI Developer
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
639 reads
My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles. I’ve been a BI developer for...
2012-07-17
639 reads
I’ve decided that the best way to spend a day of 104 degree weather is to sit inside and write...
2012-07-07
1,264 reads
I recently encountered a business scenario involving calculated members in a cube that I thought is worth sharing.
We have a...
2012-07-04
820 reads
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message...
2012-05-07
1,337 reads
My co-worker showed me an easy way to process all SQL Server Analysis Services (SSAS)cube dimensions (or measures) from the...
2012-04-02
4,307 reads
The SSIS script component can be configured to use synchronous or asynchronous outputs. If the script component is configured for...
2012-03-20
8,116 reads
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
1,000 reads
Currency conversions can be implemented several ways as part of a business intelligence solution. In some scenarios it may be...
2012-02-01
5,104 reads
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Comments posted to this topic are about the item Building AI Governance and Policies-...
Why is sql doing a full scan VS seeking on the index? I've included...
We have a report that has multiple tables that list the top 15 performers...
The DBCC CHECKIDENT command is used when working with identity values. I have a table with 10 rows in it that looks like this:
TravelLogID CityID StartDate EndDate 1 1 2025-01-11 2025-01-16 2 2 2025-01-11 2025-01-16 3 3 2025-01-11 2025-01-16 4 4 2025-01-11 2025-01-16 5 5 2025-01-11 2025-01-16 6 6 2025-01-11 2025-01-16 7 7 2025-01-11 2025-01-16 8 8 2025-01-11 2025-01-16 9 9 2025-01-11 2025-01-16 10 10 2025-01-11 2025-01-16The docs for DBCC CHECKIDENT say this if I run with only the table parameter: "If the current identity value for a table is less than the maximum identity value stored in the identity column, it is reset using the maximum value in the identity column. " I run this code:
DELETE dbo.TravelLog WHERE TravelLogID >= 9 GO DBCC CHECKIDENT(TravelLog, RESEED) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-09-14', '2025-09-17') GOWhat is the identity value for the new row inserted by the insert statement above? See possible answers