RAID 5 and SQL Server
Given that disk storage has come down substantially in price over recent years, will RAID 5 continue to be relevant as a storage configuration for databases?
2011-01-10
804 reads
Editorial
Data Loss or Downtime
This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.
2015-07-10 (first published: 2011-01-07)
238 reads
Trust People
Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.
2015-07-13 (first published: 2011-01-06)
305 reads
In Case of Breach
Do you know what to do in case of a data breach? Steve Jones talks about the importance of having a "runbook" for security that covers the same types of things you might need to know for disaster recovery.
2011-01-05
146 reads
Welcome to 2011
After the holidays, Steve Jones welcomes everyone in the SQLServerCentral community to the new year and talks about goals and your career.
2011-01-04
167 reads
Being Careful with Power
It's good to be careful with your power consumption, especially as the power cost of computing continues to grow. However with your SQL Server, you don't want to be too careful, as Steve Jones notes.
2011-01-03
289 reads
Clouds Are In our Future
Today we have a guest editorial from Andy Warren looking at the future of cloud computing and SQL Server.
2011-01-03
179 reads
Enjoying the New Year
For the last Friday poll of the year, Steve Jones has a fun one. Add your input and give everyone an idea of how to spend the last part of this holiday season.
2010-12-31
59 reads
The Year of the Community
Steve Jones looks back at 2010 and dubs it the year of the community. Join him for a look back at some events in the SQL Server world from 2010.
2010-12-30
83 reads
The Office
Would you be more productive outside of an office? Would you take a pay cut to work outside of an office? Steve Jones notes that a number of IT professionals said they would.
2015-12-07 (first published: 2010-12-29)
282 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