Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
23,392 reads
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
23,392 reads
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
25,411 reads
Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.
2011-06-20
41,325 reads
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,604 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
12,114 reads
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
12,162 reads
When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?
2010-12-17 (first published: 2010-02-24)
17,076 reads
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,652 reads
This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page
2009-09-16
9,275 reads
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
41,776 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