S3OLV April Change
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails...
2011-04-07
480 reads
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails...
2011-04-07
480 reads
Earlier this week I announced the meeting for the Las Vegas User Group. I blasted some of you with emails – along with people in our mailing list. Those...
2011-04-07
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The...
2011-04-05
536 reads
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The meeting is to be held April 14, 2011 at...
2011-04-05
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL...
2011-04-05
799 reads
How well do you know the security in your SQL instances? Do you know who has sysadmin level permissions? SQL Server provides a few methods for you to find...
2011-04-05
24 reads
As a database professional one of the things that we should be familiar with is the use of indexes. In...
2011-04-01
651 reads
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance...
2011-04-01
2 reads
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer....
2011-03-31
1,533 reads
In February I posted this post about the need for Volunteers for SUMMIT 2011. I submitted my application to volunteer. This past week I got word back concerning that...
2011-03-31
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,...
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
Comments posted to this topic are about the item The Maximum Value in the...
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