Your SQL Server is Slow, What To Look At
As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...
2024-08-12
5 reads
As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...
2024-08-12
5 reads
hiddled – adj. feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....
2024-08-09
14 reads
As someone attending the event since 2011, I would like to share my personal experience, the value of attending, and how the event has helped me throughout my career....
2024-08-09 (first published: 2024-07-24)
107 reads
What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...
2024-08-09 (first published: 2024-07-31)
117 reads
Doc Pop and Evan Prodromou discuss the past, present, and future of ActivityPub and the fediverse.
2024-08-09
21 reads
Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...
2024-08-09
16 reads
We all know that choosing the right basic SQL training is absolutely crucial if you want your SQL journey to be a success story, especially when you're starting from...
2024-08-08 (first published: 2024-08-07)
157 reads
Seven things every WordPress user should know about Gravatar
2024-08-08
23 reads
From the team at Jetpack AI comes a new tool that will improve your writing in a flash.
2024-08-08 (first published: 2024-08-06)
27 reads
Thanks to everyone who attended, though with one stage I had a fairly captive audience. I enjoyed the event and look forward to coming back to the Twin Cities...
2024-08-08
15 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