dcsimg

Search:

Type: Posts; User: FunkyDexter

Page 1 of 13 1 2 3 4

Search: Search took 0.32 seconds.

  1. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    It also says "In that scenario, Stormont would then have a vote on whether it wanted to remain aligned with Ireland - which would mean new checks on goods coming into NI from the rest of the UK." In...
  2. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    Called it back in post 249

    I know I'm being a bit smug there but I do think this sort of thinking can resolve so many of the issues we've got with Irish borders. But it does require both sides to...
  3. Replies
    48
    Views
    1,420

    Re: We are going to get the wall now...

    Yeah, I think I agree with all of that. It does beg a further question though: If we can't judge any presidency on the economy they oversee, does it follow that the presidency simply has no effect...
  4. Replies
    3
    Views
    229

    Re: Do you write joins like this?

    I write queries like that but I make heavy use of parentheses and indentation. So for me that would look a bit like this:-
    Select *
    From TableA
    Left Join (TableB
    Join TableC
    on...
  5. Replies
    48
    Views
    1,420

    Re: We are going to get the wall now...

    GDP growth is inflation and whether you're concerned with global or domestic change depends on who's holding your debt, domestic creditors vs foreign. My assertion was simplistic shorthand for "the...
  6. Replies
    48
    Views
    1,420

    Re: We are going to get the wall now...

    It's interesting that both Shaggy and Tyson identified outliers (the dot com bubble, the recession, the recent wars etc) as warping the picture. Those things often make it difficult to judge what's...
  7. Replies
    48
    Views
    1,420

    Re: We are going to get the wall now...

    I'm curious (because I genuinely don't know), how much was put on under Obama? And George W before that? And so on? I keep hearing that much of the recent economic growth has come from borrowing...
  8. Replies
    71
    Views
    1,749

    Re: Multi-Billion Dollar Idea

    Do you live in Yorkshire?





    Edit> that might not travel well outside of the UK. Not sure.
  9. Replies
    71
    Views
    1,749

    Re: Multi-Billion Dollar Idea

    I've also considered patenting reversible under-crackers...
  10. Re: [RESOLVED] SQL - Need help with an inefficient query

    Yeah, that's what I would have expected to see and the bulk of the cost is still in a table scan across CM_DMS. I'm curious as to why it's able to resolve that scan so much quicker in this approach....
  11. Re: [RESOLVED] SQL - Need help with an inefficient query

    :lol:We've all done it.

    Given what you're saying I'm not surprised you were getting slow performance. What's more confusing to me at this point is why the Left Join approach dropped the query...
  12. Re: [RESOLVED] SQL - Need help with an inefficient query

    That execution plan is very odd. It's table scanning CM_DMS 3 times despite it only being accessed once in your query (that was from the query from post 1 right?). That looks like there was some...
  13. Replies
    71
    Views
    1,749

    Re: Multi-Billion Dollar Idea

    Solar Powered Washing Lines.

    Bound to be a hit.
  14. Re: SQL - Need help with an inefficient query

    He's suggesting this approach:-

    Select distinct PB.INITS
    From PhoneBookDMS PB
    Left Join CM_DMS C
    on PB.INITS = C.Emp_ID
    Where C.Emp_ID is nullYou left join to the secondary table and then...
  15. Re: SQL - Need help with an inefficient query

    OK, at that point it really needs the execution plan examined.

    What is the data type on the INITS column in each table? In particular, are they the same? If not you could have some implicit...
  16. Re: SQL - Need help with an inefficient query

    Probably the most efficient way of doing this is by using Except:-


    (Select Distinct INITS
    From PhoneBookDMS
    Except
    Select Emp_ID From CM_DMS)
    Order By INITS
  17. Re: SQL - Need help with a query

    Apologies. The over clause should read: (Partition By RequestID Order By PhaseOrder Desc)

    The idea is that this will give a row number to each record within each request with 1 being the highest...
  18. Re: SQL - Need help with a query

    Then my query from post 5 (with a comma after PhaseOrder) should work for you.:thumb:

    Your original query from post 1 should also work but is likely to run a little slower.
  19. Replies
    48
    Views
    1,420

    Re: We are going to get the wall now...

    That pretty much covers it. Certainly remain civil to each other and, to a lesser extent, to the public figures in question as well. By choosing a public life, Trump, Obama et al, do expose...
  20. Replies
    2
    Views
    177

    Re: Trailing Spaces at INSERT and UPDATE

    The first thing I'd try is stepping outside your own application and seeing what the behaviour is. Use management studio to insert a dummy record and watch what happens. If it pads then the problem...
  21. Re: SQL - Need help with a query

    Thank you. Good spot. (The vagaries of typing straight into the forum 'cause I didn't have a demo table available I'm afraid)
  22. Thread: Hockey?

    by FunkyDexter
    Replies
    20
    Views
    514

    Re: Hockey?

    I love that film. It's great showing it to your friends for the first time and watching their reaction the first time the Hansens take the ice. Bored to hooked in ten seconds flat.

    I can see a...
  23. Re: SQL - Need help with a query

    If I'm reading the OP correctly he only wants records where record with the highest phase order has a phase of Approval. ie, he does not want USMT0000002 because the highest phase order for that has...
  24. Replies
    24
    Views
    637

    Re: Question about join order

    That makes sense. Although I'd say it's a fundamental that PKs never leak out into the outside world. Pretty much every web tutorial I've ever seen did exactly that, though.
  25. Replies
    24
    Views
    637

    Re: Question about join order

    Personally I'm not a fan of SPs when they're used to embed business logic in the database which is something I see often. I know that's debatable, though, and a lot of people like that model. Other...
  26. Replies
    24
    Views
    637

    Re: Question about join order

    Ha! Yeah, been there.

    Actually, views, particularly if they're nested more than a single level deep, are one of the worst things I've seen for breaking the optimiser. Surfacing that stuff up...
  27. Replies
    24
    Views
    637

    Re: Question about join order

    I'm looking for an article to back that up ('cause I really hate being proved wrong) and I can't find one.

    I can find some examples where people force the order the engine applies them to prove...
  28. Replies
    24
    Views
    637

    Re: Question about join order

    Not 100% sure what you mean by that.

    Do you mean that using an outer instead of an inner could change the performance? If so, yes. But it could also change the logical result so it's really a...
  29. Replies
    24
    Views
    637

    Re: Question about join order

    I'd recommend everyone read that article carefully. I'll summarise (and, admittedly, paraphrase):-

    1. The order in which the engine applies the joins absolutely matters.
    2. The order in which...
  30. Replies
    24
    Views
    637

    Re: Question about join order

    The order the tables appear in the query has no affect at all. The engine will use the statistics to project the most efficient possible execution so you should generally design a single query...
  31. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    I actually think it will be a hung parliament in one direction or the other so your probably looking at a Tory/Brexit or a Lab/Lib coalition or some sort of confidence and supply set up along those...
  32. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    Oh it absolutely is. The difference between the European governments and the EU is that the decisions in the former are made by an elected body and implemented by the bureaucracy. In the latter...
  33. Replies
    2
    Views
    291

    Re: Except analyze

    There's a few ways to skin that but probably the easiest and most explicit is something like:-

    Select *
    From Customers C
    Where Not Exists (Select *
    From Orders O
    Where O.CustomerID =...
  34. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    The problem is not just that it's just that it's distant and lacks transparency, it's that it's also uncaring and unheeding of it's constituents.
  35. Re: Help with improving my SQL query (SQLite)

    I honestly don't know enough about sqllite to comment but it sounds analogous to the Information_Schema in SQL Server. The two questions would be:-
    1. Is the constraint logically expressable?
    2....
  36. Re: Help with improving my SQL query (SQLite)

    The thing to remember here is that you can't set up a foreign key constraint that does that because "Parent Table" isn't actually a field in the parent table - it's a table name. So you can't...
  37. Replies
    48
    Views
    1,420

    Re: We are going to get the wall now...

    I can sum the first video up as:-
    "I used to run a business before China joined the WTO and had to pay export (nb, not import) tariffs"
    "China joined the WTO which meant that Export and Import...
  38. Re: Help with improving my SQL query (SQLite)

    The maximum number of iterations on this is determinate and for that reason I wouldn't recommend a recursive approach. Recursion will work but seems unnecessary in this case. This should just be a...
  39. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    We're crowdfunding his return ticket...
  40. Thread: No Deal

    by FunkyDexter
    Replies
    408
    Views
    14,626

    Re: No Deal

    I think you've got a better chance from within than from without (which was one of the reasons I voted remain) but I honestly don't think you've got a significant chance either way. A lot of Anti-EU...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width