Viewing 15 posts - 1 through 15 (of 294 total)
Can you explain how is the figure showing in cardinality is worked out?
December 2, 2019 at 5:53 pm
Second link is no longer available.
January 25, 2019 at 8:46 am
Gives a good explanation of the undocumented proc sp_readerrorlog and the parameters:-
CREATE PROC [sys].[sp_readerrorlog](
@p1 INT = 0,
December 28, 2016 at 4:35 am
Lock Partitioning is a feature in SQL Server that is automatically enabled for machines with more than 16 logical processors – aimed at reducing lock contention and cannot be disabled...
December 20, 2016 at 9:43 am
Just checking you ran the stored procs that populate the table you are querying?
December 16, 2016 at 5:06 am
I've tried updating the procedure to read
CREATE PROCEDURE [dbo].[usp_RefreshDeadockVictim]
TRUNCATE TABLE [dbo].[DeadlockVictim]
INSERT INTO [dbo].[DeadlockVictim]
December 14, 2016 at 6:22 am
Do you get anything returned when you just query the log ie:-
EXEC master.dbo.xp_readerrorlog 0, 1, 'deadlock victim=process', NULL, NULL, NULL, N'desc'
obviously I'm not sure which log it would ...
December 14, 2016 at 6:01 am
OK Thanks will sort
December 13, 2016 at 9:11 am
?There is no BEGIN so therefor no END needed or am I missing something?
December 13, 2016 at 9:02 am
We are fortunate enough to have a well over-specked server in a non 24/7 operation so I don't have to worry about running jobs like this out of hours but...
December 13, 2016 at 8:25 am
I think you already know the answer to this, to restore logs you must first restore the full backup with NORECOVERY you are trying to do something that is incorrect...
October 26, 2016 at 2:48 am
The fix for mirror backup works as expected, I tested it out on a few servers. Thanks for the great script.
September 22, 2016 at 9:45 am
Thanks I'll give it a try
September 22, 2016 at 9:35 am
That would be great thanks.
September 14, 2016 at 1:00 pm
Great script the only change I needed was to put an addition to the where clauses to ensure I did not have a problem with the script when I have...
September 14, 2016 at 8:02 am