SANS Stay Sharp Course - SEC351: Computer and Network Security Awareness
A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...
2006-06-21
2,139 reads
A few years ago I took the SANS GIAC Security Essentials Course on-line. Included in it was an attempt at...
2006-06-21
2,139 reads
Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...
2006-06-15
2,048 reads
I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...
2006-06-13
2,325 reads
It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...
2006-06-12
1,578 reads
This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...
2006-06-11
1,489 reads
I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...
2006-05-27
2,139 reads
Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:
Project Managing Latency or: How to...
2006-05-25
1,447 reads
In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...
2006-05-24
1,492 reads
I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...
2006-05-23
1,620 reads
The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...
2006-05-20
1,646 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