Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor
  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. The Lounge
  3. How is it...

How is it...

Scheduled Pinned Locked Moved The Lounge
databasesql-servercomsysadminxml
16 Posts 15 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Marc Clifton

    [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

    Thyme In The Country

    People are just notoriously impossible. --DavidCrow
    There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
    People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

    E Offline
    E Offline
    Ed Poore
    wrote on last edited by
    #5

    Repost ;P - At least if my memory serves me correctly.  I seem to remember someone commenting on a speech given by an MS developer who'd worked closely with the "product" and they were pretty embarrased when they found out it wasn't working as expected.

    1 Reply Last reply
    0
    • M Marc Clifton

      [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

      Thyme In The Country

      People are just notoriously impossible. --DavidCrow
      There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
      People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

      A Offline
      A Offline
      Anna Jayne Metcalfe
      wrote on last edited by
      #6

      I feel your pain Marc. When I first encountered SQL Management Studio my initial reaction was "very pretty". I then tried to use it, and rapidly corrected that to "very pretty, but bug-ridden and dog slow". It seems to me to be a classic case of why not to re-write a working product (SQL Server Enterprise Manager) in a new framework with an inexperienced (I can only presume, judging from logic bombs such as the one you mentioned) team of UI developers.

      Anna :rose: Linting the day away :cool: Anna's Place | Tears and Laughter "If mushy peas are the food of the devil, the stotty cake is the frisbee of God"

      R 1 Reply Last reply
      0
      • A Anna Jayne Metcalfe

        I feel your pain Marc. When I first encountered SQL Management Studio my initial reaction was "very pretty". I then tried to use it, and rapidly corrected that to "very pretty, but bug-ridden and dog slow". It seems to me to be a classic case of why not to re-write a working product (SQL Server Enterprise Manager) in a new framework with an inexperienced (I can only presume, judging from logic bombs such as the one you mentioned) team of UI developers.

        Anna :rose: Linting the day away :cool: Anna's Place | Tears and Laughter "If mushy peas are the food of the devil, the stotty cake is the frisbee of God"

        R Offline
        R Offline
        Ryan Roberts
        wrote on last edited by
        #7

        The editor is nicer. Who ever the hell thought it was a good idea to pop up a sproc editor in a modal tool window needs shooting.

        M 1 Reply Last reply
        0
        • M Marc Clifton

          [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

          Thyme In The Country

          People are just notoriously impossible. --DavidCrow
          There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
          People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

          C Offline
          C Offline
          code frog 0
          wrote on last edited by
          #8

          Try it on a slow burdened server where you will be modifying a lot of things. It sucks. Microsoft did it right. I'd kill them if they refreshed every time I changed something. One of my servers I'd lose hours on if that were the case.

          1 Reply Last reply
          0
          • R Ryan Roberts

            The editor is nicer. Who ever the hell thought it was a good idea to pop up a sproc editor in a modal tool window needs shooting.

            M Offline
            M Offline
            Miszou
            wrote on last edited by
            #9

            I agree. The first time I used SQL 2005, I couldn't figure out how to save the stored procedure, because I was so used to the modal window! I finally clicked "Execute", and was amazed at how obvious it was. :doh:

            The StartPage Randomizer | The Timelapse Project | A Random Web Page

            A 1 Reply Last reply
            0
            • M Marc Clifton

              [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

              Thyme In The Country

              People are just notoriously impossible. --DavidCrow
              There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
              People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

              R Offline
              R Offline
              Roger Wright
              wrote on last edited by
              #10

              Marc Clifton wrote:

              I really expect better quality from them.

              There's the problem. What caused such an expectation? They've never given any reason for it that I can recall.

              "...a photo album is like Life, but flat and stuck to pages." - Shog9

              1 Reply Last reply
              0
              • M Marc Clifton

                [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

                Thyme In The Country

                People are just notoriously impossible. --DavidCrow
                There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
                People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

                I Offline
                I Offline
                Ilion
                wrote on last edited by
                #11

                "I really expect better quality from them." I expect the right hand to not know what the left hand is doing.

                1 Reply Last reply
                0
                • M Marc Clifton

                  [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

                  Thyme In The Country

                  People are just notoriously impossible. --DavidCrow
                  There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
                  People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

                  C Offline
                  C Offline
                  Christopher Duncan
                  wrote on last edited by
                  #12

                  Although SQL Server is an enterprise level database and Access is just a single user convenience, in many ways I've found Access' usability to be superior to SSMS. Kinda embarrassing when their flagship database looks poor in any regard when compared to Access...

                  Author of The Career Programmer and Unite the Tribes www.PracticalStrategyConsulting.com

                  1 Reply Last reply
                  0
                  • M Miszou

                    I agree. The first time I used SQL 2005, I couldn't figure out how to save the stored procedure, because I was so used to the modal window! I finally clicked "Execute", and was amazed at how obvious it was. :doh:

                    The StartPage Randomizer | The Timelapse Project | A Random Web Page

                    A Offline
                    A Offline
                    Anna Jayne Metcalfe
                    wrote on last edited by
                    #13

                    Oh it's easier to use all right. My problem with it is that it's dog slow and riddled with silly bugs!

                    Anna :rose: Linting the day away :cool: Anna's Place | Tears and Laughter "If mushy peas are the food of the devil, the stotty cake is the frisbee of God"

                    1 Reply Last reply
                    0
                    • M Marc Clifton

                      [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

                      Thyme In The Country

                      People are just notoriously impossible. --DavidCrow
                      There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
                      People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

                      A Offline
                      A Offline
                      Anish M
                      wrote on last edited by
                      #14

                      I always thought MS never really cared about the Client Tools for SQL Server

                      1 Reply Last reply
                      0
                      • M Marc Clifton

                        [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

                        Thyme In The Country

                        People are just notoriously impossible. --DavidCrow
                        There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
                        People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

                        R Offline
                        R Offline
                        Rocky Moore
                        wrote on last edited by
                        #15

                        Well, it is hard to find other products that work as well for FREE :) Opps.. I am referring to the express version ;)

                        Rocky <>< Latest Code Blog Post: Free grid for WPF! Time limited - act now! Latest Tech Blog Post: Scratch: fun for all ages for free!

                        1 Reply Last reply
                        0
                        • M Marc Clifton

                          [rant] That Microsoft can write a tool (Microsoft SQL Server Management Studio) that requires a REFRESH on the table listed in the object explorer after changing the name of a fields via right-click modify? Did someone have a brain fart and decide not to check the schema for changes after a modify? I suspect the object explorer also doesn't automatically update after new fields have been added or deleted. I really expect better quality from them. :sigh: [/rant] The irony of it of course is that if you modify the field name in the object explorer itself (F2), then the schema updates! Marc

                          Thyme In The Country

                          People are just notoriously impossible. --DavidCrow
                          There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer
                          People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith

                          C Offline
                          C Offline
                          Chris Maunder
                          wrote on last edited by
                          #16

                          Have you ever tried Microsoft SQL Server Management Studio on a datebase across a slow network? Every right click takes seconds to show the popup menu. Every submenu in turn takes seconds. Surely they know about an object when they initially loaded the tree. They should know what commands are available for each node of the tree. So right-cliking should be instant.

                          cheers, Chris Maunder

                          CodeProject.com : C++ MVP

                          1 Reply Last reply
                          0
                          Reply
                          • Reply as topic
                          Log in to reply
                          • Oldest to Newest
                          • Newest to Oldest
                          • Most Votes

                          • Login
                          • Don't have an account? Register
                          • Login or register to search.
                          • First post
                            Last post
                          0
                          • Categories
                          • Recent
                          • Tags
                          • Popular
                          • World
                          • Users
                          • Groups