A Month of PowerShell – Day 5 (Scripting – Putting it together)
Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-05
1,646 reads
Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-05
1,646 reads
T-SQL Tuesday Party History
In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...
2013-02-08 (first published: 2013-02-05)
1,557 reads
Welcome to Day 4 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-04
983 reads
Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-03
1,608 reads
Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-02
1,839 reads
Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...
2013-02-01
2,196 reads
I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site,...
2013-01-28 (first published: 2013-01-21)
1,814 reads
This month’s T-SQL Tuesday is hosted by Jason Brimhall. Being as this is January, lots of people are making New...
2013-01-08
750 reads
I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog....
2012-12-17
13,992 reads
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...
2012-12-11
2,006 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,...
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...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
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