Your presentation matters! Do it right!
This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov...
2015-08-31
892 reads
This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov...
2015-08-31
892 reads
August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday...
2015-07-03
536 reads
So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the...
2015-05-28
3,117 reads
I am very proud to officially announce my first ever SQL Server related book, Pro SQL Server Wait Statistics! As...
2015-04-14
638 reads
On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!
I will be speaking about one of my...
2015-03-23
541 reads
A couple of days ago I had the great pleasure to join Boris Hristov in one of his awesome SQL...
2015-01-17
596 reads
In part 1 of the In-memory OLTP articles we gave you an introduction into In-memory OLTP, showing what the requirements...
2015-01-11
4,183 reads
When a new year comes around it is always a great time to reflect on the previous year.
2014 was a...
2015-01-06
419 reads
While thinking of ways to improve the way I can get SQL Server information across to those who follow my...
2014-11-30
953 reads
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or...
2014-11-27 (first published: 2014-11-21)
8,404 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
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