Viewing 15 posts - 46 through 60 (of 85 total)
Thanks very much for that. Obvious (in retrospect!)
May 26, 2017 at 2:35 am
Thanks for your reply.
What happens in the explicit transaction before that Insert Into dbo.TTemp_ActualCreateCPLI?
Probably all manner of things! So what you're saying is that all...
May 25, 2017 at 12:26 pm
Sure, but there are no foreign keys to or from either of the TTemp tables.
May 25, 2017 at 10:11 am
Sorry - I should have done that at the start.
Here's an example. A process with these details
May 25, 2017 at 9:55 am
Thanks for all of your replies and their many follow-up questions. Here are replies to some as best I can.
I'm curious. What is this supposedly complicated process?
It’s all...
April 20, 2017 at 3:27 am
Ah yes, electricity, running water ...
I think the driver is that the processing aspect is considered to be quite complicated and that TSQL isn't as good a language as...
March 31, 2017 at 9:44 am
Are there a couple of missing N in front of 'objectlock lockPartition=0' etc?
December 13, 2016 at 1:59 am
That's it!
It's also bonkers!
Why would they implement such behaviour?
December 5, 2016 at 9:32 am
SQL Guy 1 (11/8/2016)
declare @var1 varchar(max) = 'It''s now or never I ain''t gonna live forever'select len(@var1)-len(replace(@var1,' ','')) + 1
My thoughts exactly. But you probably need to boil down...
November 11, 2016 at 2:06 am
I cycle to work, so I'm mainly thinking about what other car, lorry and bus-based road users are about to do!
October 10, 2016 at 2:24 am
I've just run this on one of our databases and it returned 64 rows, which was surprising as our existing "duplicate index" checking script returned 0.
The reason is that our...
July 8, 2016 at 2:40 am
Ahhh!
So you're suggesting that my "some tables" were actually running faster when on the SSD compared to the HDD?
And if I left the "some tables" on the HDD but moved...
December 9, 2015 at 2:56 am
Probably because you've got a typo:
Create table #xyz (x int, y int, z int);
INSERT INTO #abc values
(NULL,2,3),
(NULL,NULL,1),
(NULL,NULL,2);
April 29, 2015 at 5:01 am
On the parameter sniffing suggestion, I've had a closer look at the timings of the disastrously slow call and the one section which really ballooned (from 31 seconds to 108...
February 19, 2015 at 3:17 am
Well the approach we have taken is an FK-based one. (Previously, we had used triggers.)
We have a calculated column on the parent table which is normally equal to the PK,...
June 16, 2014 at 10:12 am
Viewing 15 posts - 46 through 60 (of 85 total)