Did Not Know That - Redirecting CMD to the Clipboard
One of the items I frequently deal with as a Production DBA is drive alarms. I have written previously about...
2018-09-12 (first published: 2018-09-04)
2,858 reads
Nebraska SQL from @DBA_ANDY
The Mystery of the Exploding T-Log
There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error:
--
Log Name: ApplicationSource: MSSQLSERVERDate: 5/24/2018...
2018-08-20 (first published: 2018-08-02)
2,879 reads
Speaking This Weekend in Iowa City!
Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never...
2018-06-21
405 reads
Revoke the permission(s) before dropping the server principal
As a remote DBA I often have to log in to client systems for a fixed amount of time and...
2018-06-27 (first published: 2018-06-15)
13,350 reads
Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!
Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:
https://www.brentozar.com/archive/2018/06/announcing-a-very-special-sqlfamily-webcast-with-dr-david-dewitt/
The webcast (“SQL Query Optimization....
2018-06-09
819 reads
Speaking at PASS Summit 2018!
I found out a few days ago that one of my sessions was selected for Summit this Fall - I will...
2018-06-06
274 reads
Toolbox - How Long Has My Server Been Up?
https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)
--
As a remote service provider a common request is to follow up after a server...
2018-05-24
324 reads
When Good Query Plans Go Bad
Today's story starts again with a page escalation:
--
We are seeing very high CPU usage on DistServer01. Could you please take...
2018-05-25 (first published: 2018-05-18)
3,141 reads
Why Don't I have a Preferred Replica?
The client reported that the log file on their main database was growing unusually large, and when they checked the...
2018-04-27 (first published: 2018-04-18)
4,099 reads
Toolbox - Do You Have Current Backups?
On our managed servers we run a job each day to check that either a FULL or DIFF has run...
2018-04-04
672 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
FARE LABS Pvt. Ltd. is an Indian proficiency testing laboratory.
India's top proficiency testing facility is Fare Labs. We employ particular metrics or evaluations...
Recursive Select - What is this really doing
I've noticed several instances of what looks like a recursive insert with the format:...
Cleaning Up the Cloud
Comments posted to this topic are about the item Cleaning Up the Cloud
Question of the Day
The Maximum Value in the Identity Column
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 OFF
I now run this code.
DBCC CHECKIDENT(TravelLog)
GO
INSERT dbo.TravelLog
(
CityID,
StartDate,
EndDate
)
VALUES
(4, '2025-10-14', '2025-10-17')
GO
What is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025?
See possible answers