I haven’t used these products but is there an execution plan, and if so is it built some time before execution, or just prior? I’m wondering whether an execution plan might be different (carp) if run against small test datasets rather than a huge live one. That is, the order the joins are done might affect performance significantly, and I don’t recall a method of forcing the issue in SQL.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
HELP - Agent has put me in a job overseas with no interview, and my skills don´t fit
Collapse
X
-
-
Originally posted by Gonzo View PostThere are but they don't like you mentioning it as it is something of a goldmine for them.Comment
-
Well I survived the short contract. Client now talking about possibly asking me back in the new year, but nothing definite.
What I did was to get on to rentacoder.com and post my problems there. I got a reply from a UK-based experienced SQL Server DBA, and he spent a couple of hours on the skype phone in the evening at the client going through and sorting the problems. Only 25 quid and hour he charged - he was trying to operate a business for multiple clients to escape IR35, so a win-win situation all round it seems.
Of course the way I played it with the client was that I was part of a consultancy, and "the service we offer you consists of input from me and our other experienced consultants"...Comment
-
Well played. But time to bone up on it yourself now, don't you thinkConfusion is a natural state of beingComment
-
Originally posted by KentPhilip View PostWell I survived the short contract. Client now talking about possibly asking me back in the new year, but nothing definite.
Sorted.Drivelling in TPD is not a mental health issue. We're just community blogging, that's all.
Xenophon said: "CUK Geek of the Week". A gingerjedi certified "Elitist Tw@t". Posting rated @ 5 lard pointsComment
-
Originally posted by KentPhilip View PostWell I survived the short contract. Client now talking about possibly asking me back in the new year, but nothing definite.
What I did was to get on to rentacoder.com and post my problems there. I got a reply from a UK-based experienced SQL Server DBA, and he spent a couple of hours on the skype phone in the evening at the client going through and sorting the problems. Only 25 quid and hour he charged - he was trying to operate a business for multiple clients to escape IR35, so a win-win situation all round it seems.
Of course the way I played it with the client was that I was part of a consultancy, and "the service we offer you consists of input from me and our other experienced consultants"...Down with racism. Long live miscegenation!Comment
-
So what was the answer?Comment
-
Originally posted by NotAllThere View PostWell done! I suggest now you invest in a SAP Basis course. You've got the experience - so it's a good time to get the training.Comment
-
Originally posted by TimberWolf View PostSo what the answer?
Finally I ran alter index all on <tablename> rebuild with (ONLINE = ON)
This query ran and ran, and I eventually had to manually kill it. But half way through I ran the original query, and it took only 4 seconds to run, with a radically different query plan.
The tempdb never filled up during the time I was there - so a SAP index error they had received, that I got them to resolve, must have been the problem.
As for the third problem, not resolved yet, but I'm writing them a script for reindexing (on more than 1000 tables - eek!), and if that doesn't work, will suggest more drives in the data drive SAN to increase disk io.Comment
-
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment