Live Monitoring
You can get a look into how SQLServerCentral handles the load of it's database servers with a new tool, and release of reports.
2010-11-11
343 reads
Editorial
Automated Driving
Could we ever have computers automating our cars and handling the driving for us? Steve Jones doesn't think so, despite some ongoing projects.
2010-11-10
113 reads
Code of Conduct for Software Maintenance
A number of companies came together to develop a code of conduct recently for software vendors. Steve Jones thinks this is a good idea.
2010-11-09
213 reads
Should You Write Down Your Passwords?
Today we have an older editorial by Steve Jones being republished. This piece talks about security and why it might be a good idea to write down those passwords.
2010-11-08
268 reads
Enterprise Management
This Friday Steve Jones asks the question about how you manage large numbers of SQL Server instances.
2010-11-05
210 reads
One Time Passwords
Facebook has implemented a new security feature that Steve Jones thinks might work well for SQL Server as well.
2010-11-04
258 reads
Swarms
Steve Jones talks about the workplace of the future, and a prediction from the Gartner Group that it will include swarms.
2010-11-03
138 reads
Life Without a Net
Today we have a guest editorial from Rodney Landrum that talks about life in the past, when we couldn't look up everything on the Internet.
2010-11-02
212 reads
Can I really drop that index?
You believe that an index is unused and so could be removed, and yet, your finger hovers nervously over the metaphorical "delete" button. You can't quite bring yourself to do it. Is it really safe to drop this index? Tony wonders if "invisible indexes" might solve this dilemma.
2010-11-01
383 reads
Happy Halloween 2010
Steve Jones has a day off before SQL Server Connections and brings us a blooper reel for Halloween.
2010-11-01
97 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
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...
Don't Forget About Financial Skills
Comments posted to this topic are about the item Don't Forget About Financial Skills
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