T-SQL Tuesday #45 – Who’s Auditing My SSIS Packages?
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is...
2013-08-13
862 reads
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is...
2013-08-13
862 reads
I recently encountered a DBCC CHECKDB failure with a fairly non-specific failure message. The error message said it terminated abnormally...
2013-07-24
7,215 reads
Lately, I’ve been finding more and more reasons to look in the transaction log for investigative purposes. Questions come up...
2013-05-27
1,195 reads
A little more than a year ago while working at Idera, I was consulted on reports from a few clients...
2013-05-21
1,211 reads
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...
2013-04-09
1,148 reads
It has been a long journey to the final day my 31 Days of Disaster Recovery series, but we have...
2013-03-28 (first published: 2013-03-25)
2,414 reads
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,264 reads
It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with...
2013-03-12
1,337 reads
I am currently going through the process of looking for a new opportunity for my career. I’m going through the...
2013-03-08 (first published: 2013-03-01)
6,031 reads
For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from...
2013-02-25
1,338 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 The Maximum Value in the...
Hi, it isnt clear from the web if something like this should work as...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
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