SQL Server +0 and -0
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,558 reads
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,558 reads
SQL Saturday 198, http://www.sqlsaturday.com/198/ ; is coming to Vancouver Feb 16 this year. As of now, 56 sessions are collected from...
2013-01-09
819 reads
We know that we need to take special attention about NULL values while writing queries because they may lead us into...
2012-12-26
2,311 reads
Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...
2012-10-17
2,423 reads
Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...
2012-10-10
1,436 reads
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,300 reads
Quite often people need to write a new T-SQL application to replace an existing one for various reasons. For instance,...
2012-07-06 (first published: 2012-06-29)
4,150 reads
With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...
2012-06-26
2,742 reads
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,086 reads
DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...
2011-11-23
2,803 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