Pluralsight courses available with MSDN Subscription
One of the benefits of having an MSDN Subscription is that you have free access to some Pluralsight courses.
To verify this,...
2016-09-08
506 reads
Sifiso W. Ndlovu
Master Data Services Insufficient Memory Error
A business case that requires the usage of Master Data Services finally landed in my desk. As part of delivering...
2016-08-24
574 reads
Resolving Windows Folder Access Denied Error
I previously got rid of my desktop when its motherboard got damaged. Prior to throwing it away, I recovered its...
2016-08-17
163 reads
Resolving PolyBase Installation Errors in SQL Server 2016
One of the exciting new features you may want to explore in SQL Server 2016 is PolyBase. However, as I...
2016-07-15
1,207 reads
Single package deployment does not replace package deployment
In my article, Single package deployment in SQL Server Integration Services 2016, I covered the exciting single package deployment feature...
2016-06-30
481 reads
SQL Server Exercise for Data Warehouse Candidates
Background
Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire...
2016-05-30 (first published: 2016-05-20)
2,570 reads
How to Trim Characters in C#
The removing of leading and trailing characters in c# is made possible by the System namespace.
My demo is uses a windows...
2016-04-18
461 reads
Multiple Tagging of TFS Work Items Using Excel
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can...
2016-03-30
999 reads
Duplicate MySQL Table Using phpMyAdmin
There many reasons for creating copies of existing relational database tables. Sometimes you create duplicate tables for the purposes of...
2015-11-14
3,554 reads
Where’s my Team Explorer 2015?
Team Explorer is a client software that can be used to integrate Visual Studio with an instance of Team Foundation...
2015-11-03
403 reads
Blogs
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Cloud Data Driven User Group 2025 – Slides & Scripts
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
Leading Through Change: Guiding Teams in Times of Uncertainty
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Forums
Building AI Governance and Policies- First Steps
Comments posted to this topic are about the item Building AI Governance and Policies-...
Simple delete causes table scan on other tables with foreign key
Why is sql doing a full scan VS seeking on the index? I've included...
Show/Hide number of rows in table
We have a report that has multiple tables that list the top 15 performers...
Question of the Day
Checking Identities
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')
GO
What is the identity value for the new row inserted by the insert statement above? See possible answers