dalski's latest activity

  • D
    dalski reacted to RonPaii's post in the thread Solved SSMS22 Application Itself Slower Than SSMS21 with Like Like.
    I have had issues with v3 fixed by setting LeasingMode to none on server share with Access BE files. It does slow down BE. With this...
  • D
    dalski reacted to GPGeorge's post in the thread Using SQLServer with Like Like.
    "... it makes it really easy to find ...." (y) I would add, "... and to make it clear what is happening." As I get further away from...
  • D
    dalski reacted to Minty's post in the thread Using SQLServer with Like Like.
    Personally, it all depends on whether someone else is likely to look at it later... If they are I tend to be a bit more formal. I do...
  • D
    dalski reacted to cheekybuddha's post in the thread Using SQLServer with Like Like.
    Please reference Post #26. I never said that you shouldn't use EXEC, just that you do not have to use it, which was the information...
  • D
    dalski reacted to DaveMD's post in the thread Using SQLServer with Like Like.
    I have the same thought as @GPGeorge and @Albert D. Kallal on this point. Too often a developer will come across some shorthand way to...
  • D
    dalski reacted to GPGeorge's post in the thread Using SQLServer with Like Like.
    Thank you. I think this is another case where I adopted the practice of using full syntax regardless of whether it's required or not.
  • D
    dalski reacted to Albert D. Kallal's post in the thread Using SQLServer with Like Like.
    What's that saying about the juice is not worth the efforts to squeeze the fruit or some such? Typing in "exec" not going to wear out...
  • D
    dalski reacted to Albert D. Kallal's post in the thread Using SQLServer with Like Like.
    Actaully, in both SSMS, or even a PT query from Access? You don't need the EXEC in front in most cases. So, from SSMS, then these will...
  • D
    dalski reacted to cheekybuddha's post in the thread Using SQLServer with Like Like.
    Hi George, You don't need to preface sp's with EXEC to get them to execute on SQLServer. As an example, I have a sp called...
  • D
    dalski reacted to Albert D. Kallal's post in the thread Using SQLServer with Like Like.
    Ok, for sure then, start out using SSMS to create, manage, change, add, modify the tables. You find SSMS not a whole lot different then...
  • D
    dalski reacted to cheekybuddha's post in the thread Using SQLServer with Like Like.
    You don't need to use EXEC or GO
  • D
    dalski reacted to GPGeorge's post in the thread Using SQLServer with Like Like.
    SSMS is tightly coupled to SQL Server in the sense that it is designed to work with SQL Server databases. However, it's important not to...
  • D
    dalski reacted to Minty's post in the thread Using SQLServer with Like Like.
    You can run a T-SQL command on a SQL server without SSMS ever being installed. Just run a passthrough query from MS Access. To...
  • D
    dalski replied to the thread Using SQLServer.
    Thanks George, oh that's surprising. I would've thought it was tightly coupled with SSMS due to TSQL. I would never have thought it...
  • D
    dalski reacted to GPGeorge's post in the thread Using SQLServer with Like Like.
    SQL Server Migration Assistant for Access (SSMA) is a tool that migrates tables from Access to SQL Server. SQL Server Management Studio...
Show older items
Back
Top Bottom