SQLgetinfo

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Robert
    #1

    SQLgetinfo

    I am new to Access/SQL server. I need to determine for performance which
    aggregate functions are not supported by SQL Server. I understand one way
    is to query the server to see if the function has to run locally or it can
    run remote. How can I poll the server?


    Tags: None
    • Guinness Mann
      #2
      Re: SQLgetinfo

      In article <HMDHu2.CAM@new s.boeing.com>, stop.spam@white house.gov
      says...[color=blue]
      > I am new to Access/SQL server. I need to determine for performance which
      > aggregate functions are not supported by SQL Server. I understand one way
      > is to query the server to see if the function has to run locally or it can
      > run remote. How can I poll the server?[/color]

      Access is like a car. SQL Server is like an airplane. Cars can go on
      the ground. Airplanes can fly.

      Does that help?

        Comment

        • Robert
          #3
          Re: SQLgetinfo

          Yes, major help. Thanx!

          "Guinness Mann" <GMann@dublin.c om> wrote in message
          news:MPG.19ec91 39ad8f98ac9896e 5@news.newsguy. com...[color=blue]
          > In article <HMDHu2.CAM@new s.boeing.com>, stop.spam@white house.gov
          > says...[color=green]
          > > I am new to Access/SQL server. I need to determine for performance[/color][/color]
          which[color=blue][color=green]
          > > aggregate functions are not supported by SQL Server. I understand one[/color][/color]
          way[color=blue][color=green]
          > > is to query the server to see if the function has to run locally or it[/color][/color]
          can[color=blue][color=green]
          > > run remote. How can I poll the server?[/color]
          >
          > Access is like a car. SQL Server is like an airplane. Cars can go on
          > the ground. Airplanes can fly.
          >
          > Does that help?
          >[/color]


            Comment

            • Guinness Mann
              #4
              Re: SQLgetinfo (Erland)

              In article <HMEDI0.Dn7@new s.boeing.com>, stop.spam@white house.gov
              says...[color=blue]
              > Yes, major help. Thanx![/color]

              Seriously, there is not a great deal of intersection between the two
              products, other than that they are made by Microsoft and there are some
              utilities to help you upgrade from Access to SQL Server.

              In SQL Server, *all* queries run remotely. In Access (well, the jet
              database engine, which is what you will be communicating with), *all*
              queries run locally. I found that out the hard way when I created a 300
              MB mdb (Access) database at a site in Wales and then went back to my
              office in San Diego and tried to run queries against it over a 64k ISDN
              line. For each query the entire 300 MB database had to be transferred
              from Wales to California, one record at a time. Had I used SQL Server,
              only the results would have had to be transferred.

              It sounds like you need to do a little bit of reading. Erland will be
              along in a little while to give you a URL where you can download the
              help files for SQL Server (known around here as the "bol"). Read some
              of the introductory material in there and then come back with some more
              specific questions.

              --
              Who's better for furniture? NOOOOOOOOOOOOOO OOOOBODY!!!!
              --

              Guinness Mann
              GMann@Dublin.co m

                Comment

                Previous template Next
                Working...