Search results

  1. D

    Solved SSMS22 Application Itself Slower Than SSMS21

    Update - I dropped & recreated the db; faster opening an object from Object Explorer (1.5 secs). Then added a relationship in the Table Design View; took around 30 secs to load up initial GUI (not Diagram) then after selecting columns 40 secs to add relationship. Then the Diagram took around 90...
  2. D

    Solved SSMS22 Application Itself Slower Than SSMS21

    Thanks George, I've also tried: Disabling Publisher Certificate Revocation Check in Windows Modified Host File For Certificate Revocation; C:\Windows\System32\drivers\etc\hosts adding 127.0.0.1 crl.microsoft.com to bottom of file No luck on above tried resetting connection settings of SSMS 22...
  3. D

    Solved SSMS22 Application Itself Slower Than SSMS21

    Thanks Tom, really good of you; interesting, I definitely have a problem which I should solve then.
  4. D

    Solved SSMS22 Application Itself Slower Than SSMS21

    Thanks Tom, that's helpful. I knew Azure would be slower but surprised with Diagrams atm. I hardly have any data in the db but through Access it's very quick but we'll see how it goes when I get a bit more done. Still a lot to do on the development side.
  5. D

    Solved SSMS22 Application Itself Slower Than SSMS21

    Hi @sonic8 , I'm usually wrong & know very little, but I thought I saw some posts with people having issues with the ODBC. I thought ODBC strings is how we connect. Well if that's your assumption given your knowledge I'm certainly wrong. I got a prompt on installing the new app about OLE/ ODBC...
  6. D

    Solved SSMS22 Application Itself Slower Than SSMS21

    Have many experienced this? I'm not talking about through Access or Query performance, I mean the actual application SSMS22 itself is extremely slow. Through Access is quick but I'm working in SSMS most of the time converting the BE for Access. Seems there are quite a few complaints with the...
  7. D

    Solved Do Calculations Inside Decimal Data-Type Suffer Memory Truncation?

    Beautiful link @RonPaii, thank you, I didn't come across that MSN article which was exactly what I needed. It used to be a popular phrase In English/ Irish communities. I've rarely heard it from my age group, but working on site with the older Irish generation it was commonly used, but less so...
  8. D

    Solved Do Calculations Inside Decimal Data-Type Suffer Memory Truncation?

    Thanks Doc, I am aware of the enigma with multiplication & division, but thank you for prompting had I not been aware. Don't worry about the possibility of different data-types being used as terms within the expression; I have this covered. I also have it covered where the decimal places...
  9. D

    The_Doc_Man has become upgraded to Super Moderator

    Congrats @The_Doc_Man, well deserved!
  10. D

    Solved Do Calculations Inside Decimal Data-Type Suffer Memory Truncation?

    Thanks Doc, Access will be fine with 17 decimal points to display enough accuracy, it is the calculations done in the back-end where i need the accuracy. Are you saying that I need to explicitly round all intermediate calculations regardless of their specified decimal point spec? An...
  11. D

    Solved Do Calculations Inside Decimal Data-Type Suffer Memory Truncation?

    Thanks Ron, most intermediate calc's are Decimal(38,26) so it seems type-inheritance applies. I'll round intermediate calc's where <> (38,26). Overflow Errors - thanks, there's always going to be a limit so I'm not too worried about this as I'm designing around reasonable spec's for the...
  12. D

    Solved Do Calculations Inside Decimal Data-Type Suffer Memory Truncation?

    I'm no mathematician either, but I need to be accurate to 26 decimal places to minimise nested compounding; playing it safe to minimize problems. I do need big numbers mind as the calculations need to be as accurate as possible with linear regression (probably the wrong term). It's quite a pig...
  13. D

    Solved Do Calculations Inside Decimal Data-Type Suffer Memory Truncation?

    Will the specification of the Decimal data-type apply to all calculations wrapped inside the Decimal data-type & each calculation inherit the accuracy specified by the parent Decimal type (26 decimal points in e.g.). I'm hoping it does because I have complex calculations which I do not want to...
  14. D

    Solved Avoid Duplicates Of Multiple Fields

    Thanks George, much appreciated, I'll go composite index route.
  15. D

    Solved Avoid Duplicates Of Multiple Fields

    In Access I used a composite index of 2 fields, but unsure best option in MSSQL for performance to avoid a duplicate record of the combination of the 2 fields? In the child table (relevant to topic) I have a foreign-key & a normal field. I think I have 2 options? Composite Index like in...
  16. D

    Table Design and Efficiency Help

    You have a great understanding for a first post. So obviously the below Entity Relationship Diagram (ERD) is not going to be fully correct (no doubt massively wrong knowing me) but a gist. Pretty much everyone on the forum is more capable than myself, but in trying to lend a helping hand; I...
  17. D

    Solved It takes too long to download data from server

    @GPGeorge, thank you so much for taking time out of your day for this articulate explanation (the best I've come across after a week or so full-time research where full detailed articles & all MSN research... don't compare to this fine explanation). After much research I could not ascertain...
  18. D

    Solved It takes too long to download data from server

    I would think the OP will require the recordset of the form to be editable, but enjoy the benefit of fast calculated fields in the view/ stored procedure/ function used inside a field of the query. 1 - Testing on a view in MSSQL; which is editable. The view then needs to be reloaded & the...
  19. D

    Solved Del All FK & PK Constraints

    No that's helpful info, thanks for sharing.
  20. D

    Solved Del All FK & PK Constraints

    Thanks Dave, ok I'm greatly outvoted here & I take onboard a unanimous vote from the experts with much greater experience than me. Thank you all for your input, greatly appreciated.
Back
Top Bottom