Viewing 11 posts - 1 through 11 (of 11 total)
Yes its mixed mode. The Trace log is useful, as there are some connections happening for that user. If I connect before starting the SqlDependency - it works; after the...
July 28, 2021 at 1:54 pm
Great tip about system_health. I didn't realise so much more information was recorded.
I have extracted the xml_deadlock_report events - and the results are unexpected. And probably much easier to fix.
May 4, 2021 at 1:27 pm
The errors I am getting are all like this:
Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the...
May 4, 2021 at 11:12 am
As I'm developing under a deadline, I went with the first answer. And I'm developing with limited data, and we are expecting no more than a few thousand at...
December 15, 2020 at 1:00 pm
Brilliant. Great solution
I knew I'd come across this before, but "gaps and islands" are terms I'd forgotten , so I can now search properly for this type of problem.
September 3, 2019 at 3:26 pm
Yes Jeff your new version works in Azure just fine
SELECT TOP 11000 N = IDENTITY(INT,1,1) INTO dbo.Tally...
July 11, 2019 at 12:43 pm
A minor point I came across today - your "favourite way" to produce the Tally table does not work in an Azure database:
SELECT TOP 11000 --equates to...
July 10, 2019 at 9:09 am
I've figured it out - using the MERGE statement instead of INSERT
DECLARE @CrossRef TABLE ( MyTable_ID INT, C_C VARCHAR(10) );DECLARE @MyData TABLE ( ID...
March 4, 2019 at 9:48 am
The help on the OUTPUT clause seems to suggest that data not deleted can be accessed in the DELETED table
I want to find out...
March 4, 2019 at 9:29 am
@joe[What you are asking us to help you do is a design flaw called...
January 3, 2019 at 2:38 am
And thank-you for your suggestions.
I Decided the Dynamic SQL route fitted my problem best.
The results go to an Excel Report for the end user - not to any...
January 2, 2019 at 2:59 am