One Month with the Dell Latitude 7450
It was just over a month ago that I got a Dell Latitude 7450 from our corporate IT group. It wasn’t my first choice, but as Redgate grows, they’re...
2024-08-23
10 reads
It was just over a month ago that I got a Dell Latitude 7450 from our corporate IT group. It wasn’t my first choice, but as Redgate grows, they’re...
2024-08-23
10 reads
I’m still learning PostgreSQL and one of the things I’ve been looking at a lot lately is instrumentation. What do I mean? Well, if you’re in SQL Server, think,...
2024-08-23 (first published: 2024-08-05)
138 reads
I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to...
2024-08-23 (first published: 2024-08-09)
361 reads
2024-08-23
17 reads
Syracuse is having their first SQL Saturday on Sept 7, 2024. I’ll be there and hope to see you there as well. If you’re anywhere close, come on over...
2024-08-22
25 reads
On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...
2024-08-21 (first published: 2024-08-09)
349 reads
A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...
2024-08-21 (first published: 2024-08-12)
206 reads
In this post, we share the strategies and techniques we've implemented to ensure our Electron-based Studio app runs smoothly, delivering a high-performance user experience.
2024-08-20
16 reads
The post How to Excel in Board Meetings as a CFO appeared first on Joyful Craftsmen.
2024-08-20
8 reads
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-08-19
194 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