Find Index Create Date
This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...
2019-12-25
345 reads
This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...
2019-12-25
345 reads
This article shows a quick script to help determine indexes that were created recently. This script will help you out of rough spot and help reduce the chance of...
2019-12-25
4 reads
This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:
Linked Servers and Stats October 17,...
2020-01-02 (first published: 2019-12-20)
1,361 reads
This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.
Related Posts:
Implicit Conversion Fail May 31, 2019...
2019-12-20
639 reads
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...
2019-12-17
176 reads
So you come along one day to validate some service configurations for the SQL Server services and instead of the SQL Server Configuration Manager opening as expected, you are...
2019-12-17
1 reads
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...
2020-01-06 (first published: 2019-12-13)
562 reads
Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way...
2019-12-13
2 reads
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:
When Too Much is Not a Good Thing December 13,...
2019-12-30 (first published: 2019-12-12)
437 reads
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:
When Too Much is Not a Good Thing December 13,...
2019-12-12
2 reads
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
I've noticed several instances of what looks like a recursive insert with the format:...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers