Viewing 15 posts - 46 through 60 (of 82 total)
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
Sorry, I should have said. Yes, each is a header - detail type of arrangement. In my example of "parent = an organisation, child = a contract held with that...
June 13, 2014 at 9:54 am
Thanks very much for all your comments - greatly appreciated that you've taken the time. As far as answers go, this is what we're looking for:
Question #1
1 1 1 21
1...
June 6, 2014 at 9:00 am
Viewing 15 posts - 46 through 60 (of 82 total)