How to find SQL Agent Jobs without Notification Operator Configured?
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,615 reads
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,615 reads
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,482 reads
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,242 reads
SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference...
2012-08-02
2,862 reads
In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...
2012-08-02
9,854 reads
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,866 reads
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2012-07-27
1,581 reads
Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...
2012-07-26
2,914 reads
Today, I’ve written the following T-SQL script which you can use to monitor the status of transactional replication and performance...
2012-07-25
7,016 reads
Industry guidance such as the Payment Card Industry Data Security Standard (PCI-DSS), Healthcare Insurance Portability and Accountability Act (HIPAA) and...
2012-07-19
15,553 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
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