Will We See You Tomorrow at WordCamp US 2021?
Let's meet at WCUS 2021! We'll be there and we hope to see you there as well!
2021-09-30
41 reads
Let's meet at WCUS 2021! We'll be there and we hope to see you there as well!
2021-09-30
41 reads
For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and brand that she never thought was possible.
2021-09-27
37 reads
This month, our team released features in the block editor that give your site a little breathing room: spacing controls for buttons and paragraphs. And the List View tool...
2021-08-31
32 reads
We are proud to feature Jessica Petrie of Yoga Next Door, HBCU Gameday, and other inspiring customers at the second Official WordPress.com Growth Summit, on Tuesday, August 17.
2021-08-16
27 reads
Great news: the block editor you’re familiar with in pages and posts is now part of the widgets editor.
2021-08-10
12 reads
We’re committed to helping you create a professional online presence with WordPress.com, and we’re launching a three-month free trial with Professional Email to get you started. Professional Email is...
2021-08-03
55 reads
With the WordPress 5.8 release, we're starting to introduce features that overall improve your visual editing experience.
2021-07-27
15 reads
Join us online August 17 (Americas) or August 18 (Asia-Pacific). Register today!
2021-07-26
15 reads
Photos on your website can be a representation of who you are, what you do, or what you love. We want your photos to show to your visitors as...
2021-07-22
18 reads
Learn how WordPress.com's managed hosting powers fast, secure websites.
2021-07-20
14 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