Drive
What motivates people? What makes them happy at their jobs? Steve Jones talks about Drive, the book by Dan Pink, and the possibility that people actually like doing their jobs and are willing to work.
2011-02-24
205 reads
Editorial
Commuting Pain
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
2011-02-23
225 reads
Archiving Little Used Data
How do you decide what to archive? Steve Jones says that you need to come up with a method as our data sizes grow larger and larger all the time.
2011-02-22
275 reads
What's Your Code Quality?
Today we have an editorial reprinted from Jan 3, 2006 as Steve is on vacation. What's the quality of your code? Do you measure it? And does it matter?
2011-02-21
268 reads
Getting Up To Speed on SQL Server Denali
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
2011-02-21
482 reads
2011-02-18
138 reads
The Stairway Series
Today we launch a new series of content aimed at providing basic knowledge to people new to a section of SQL Server. Steve Jones comments on the way this series came about.
2011-02-17
691 reads
What Sarbanes-Oxley Won't Do
Today we have a reprint of an editorial from Dec 4, 2005 as Steve is on vacation.
2011-02-16
159 reads
Data Quality
Today we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.
2011-02-15
261 reads
A Variety of Interpretations
This week was T-SQL Tuesday week, the brainchild of Adam Machanic, and hosted by Pat Wright. The theme of Automation produced some very interesting posts. Some of them might inspire you to change the way you tackle the solutions for a variety of problems.
2011-02-14
93 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
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...
Replication from IBMi DB2 to MS SQL
We have a tool called DB Moto that reads journals (like t-logs) and replicates...
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