Updated SQLRally Flyer
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
712 reads
We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...
2010-12-23
712 reads
I read a lot, and often marvel at the effort that goes into writing them, and I think I get...
2010-12-22
614 reads
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
579 reads
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
579 reads
This Friday we have a guest editorial from Andy Warren that asks about those features in SQL Serve that you find very useful, but perhaps aren't as well known.
2010-12-17
585 reads
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
592 reads
Our December meeting was a time for a lot of changes:
New location, the Hampton Inn in Lake Mary. It’s further...
2010-12-16
588 reads
Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...
2010-12-15
868 reads
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
608 reads
I’ve happened to have a few networking events happen recently that I thought I’d share, all part of trying to...
2010-12-13
645 reads
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
The slidedeck and the SQL scripts for the session Indexing for Dummies can be...
By Chris Yates
Change is not a disruption in technology; it is the rhythm. New frameworks appear,...
Comments posted to this topic are about the item Building AI Governance and Policies-...
Why is sql doing a full scan VS seeking on the index? I've included...
We have a report that has multiple tables that list the top 15 performers...
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') GOWhat is the identity value for the new row inserted by the insert statement above? See possible answers