PromptSQL purchased by Red Gate Software
It appears that PromptSQL has been purchased by Red Gate Software. I
haven't seen a news announcement about it, and there's...
2006-05-04
1,524 reads
It appears that PromptSQL has been purchased by Red Gate Software. I
haven't seen a news announcement about it, and there's...
2006-05-04
1,524 reads
SQL Server 2005 Books Online has been updated for SP1. The newest
version is labeled SQL Server 2005 Books Online (April...
2006-05-04
1,525 reads
I'm catching back up on the TechNet webcasts
I found interesting from April. Most are during the day and with
meetings and...
2006-05-01
697 reads
This question comes up enough on the forums and with SP1 for SQL Server
2005 released, I'll cover it again. You...
2006-04-30
1,598 reads
This study out of the University of Illinois at Urbana-Champaign sounds great:
Software Allows Neighbors To Improve Internet Access At No...
2006-04-30
1,590 reads
In this post,
I talked about using xp_logininfo in order to get the permission paths
for a particular Windows account. If you've...
2006-04-29
10,552 reads
I was catching up on my blog reading and found the following post from Jamie Thomson:
SSIS: Another SP1 problem
The post...
2006-04-28
1,446 reads
There have been reports of some issues with SQL Server 2005 SP1, especially
with SQL Server Integration Services not starting as...
2006-04-27
1,619 reads
I have MVP Raymond Lewallen in my list of blogs to follow. I read with great sadness the following blog...
2006-04-26
1,457 reads
I received an email from another DBA asking how to track a user who is
probably mapping into SQL Server via...
2006-04-25
1,584 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