Presenting at SQL Saturday #111
On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-03-28
704 reads
On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-03-28
704 reads
SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...
2012-03-15
2,941 reads
This month, Argenis Fernandez (blog, @DBArgenis) is hosting our monthly T-SQL Tuesday, and he wants to know: Are you specialized?...
2012-03-13
943 reads
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,399 reads
Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...
2012-02-15
80,878 reads
I’m honored to have been selected to present two sessions at SQL Saturday #96 in our nation’s capital, Washington DC...
2011-11-02
785 reads
On Saturday, October 29, 2011 at 2:45 pm, I’ll be presenting “Table Vars and Temp Tables – What you NEED to...
2011-10-27
696 reads
Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog...
2011-10-26
805 reads
Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...
2011-10-17
1,456 reads
There is something wrong in the SQL force today… here it is the first Tuesday of a month, and we’re...
2011-10-04
793 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