Database Snapshots – A view of database at a specific point in time
Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting...
2012-12-11
878 reads
Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting...
2012-12-11
878 reads
Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...
2012-12-02
815 reads
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
2012-12-02
633 reads
Checkout my article here, in which I talked about the basic steps that are requried to plan an successful ETL...
2012-12-02
706 reads
Problem
After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application...
2012-11-15
1,906 reads
Reblogged from Basit's SQL Server Tips:
This article walks the user through installation of SQL Server 2012 on a Windows Server...
2012-11-11
1,272 reads
The database expansion costs money, not just software licenses. It costs money in maintenance and hardware, and also impacting businesses...
2012-11-11
1,077 reads
Problem
The SQL Server Database Engine returns the following error message after a service broker enabled database is restored to the...
2012-10-24
3,759 reads
Before SQL Server 2012, when we move or restore databases to a different SQL Server instance, then any logins associated...
2012-10-24
879 reads
Locking is a necessary part of transaction processing when working in a multi-user Online Transaction Processing (OLTP) environment. You use...
2012-10-21
12,290 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...
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:...
Comments posted to this topic are about the item Cleaning Up the Cloud
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