Search results

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...

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...

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

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.

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...

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...

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...

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...

Congrats @The_Doc_Man, well deserved!

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...

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...

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...

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...

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

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...

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...

@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...

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...

No that's helpful info, thanks for sharing.

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.