Data Page math : 96 + 8060 + 36 = 8192. is this correct?
I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...
2012-02-09
1,702 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
Important SQL Notes collection by Jose Barreto
I have come accross below link while checking options to find top painful mirroring enabled databases.
Looks like there is no single...
2012-01-31
4,572 reads
Free SQL Server Learning Resources
As a learner I have got chance to know lots of free and precious SQL Server resources in last few...
2011-11-05
2,481 reads
Four faces of an Employee
Whoever starts their career in any domain/technology, initially they will have two faces.
First face of an employee is to take...
2011-10-31
1,731 reads
Logical CPU, Physical CPU and hyper threading
Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.
-- Hardware information from...
2011-10-30
11,463 reads
Database Snapshot as a Reporting Solution – Some Realtime Issues and Answers
One of Our production database is used by lots of Reporting users. Mirroring is enabled on this database. But no one is...
2011-09-19
6,823 reads
Father of SQL Server?
“I love SQL Server. SQL Server has given me good career, salaray and life”
“Be loyal and dedicated with SQL Server....
2011-09-19
2,864 reads
Youngest MCM in the world?
As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...
2011-09-05
1,487 reads
Chennai SQL Server User Group and me
My one week long search to identify active SQL Server community in Chennai ended last Sunday.
Chennai SQL Server User Group...
2011-08-07
2,014 reads
SQL Server, Chennai and Me
It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.
While...
2011-07-26
887 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