The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,183 reads
A series of articles based on the Query Answers with SQL Server book.
2018-06-29
4,183 reads
In this article I want to provide an introduction to the vital set of functions that help you to use a time element when analyzing data
2017-10-27 (first published: 2016-06-06)
7,055 reads
This article shows you how to create dynamic slicers from a data set in an SSRS report
2017-02-02 (first published: 2015-04-23)
16,813 reads
Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals
2016-05-31
10,863 reads
In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data
2016-05-23
1,427 reads
This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database
2015-08-03
7,066 reads
Optimize SSIS data loads using parallel processing and the Balanced Data Distributor
2015-07-02
7,527 reads
Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.
2015-06-11 (first published: 2009-02-26)
33,649 reads
Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI
2015-05-21
8,796 reads
Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.
2015-04-13
10,070 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