User Profile

Collapse

Profile Sidebar

Collapse
Rudurk
Rudurk
Last Activity: May 14 '15, 11:32 AM
Joined: Aug 15 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Rudurk
    replied to Making a new table from a SQL Server Query to MS Access.
    in SQL Server
    I opted to go for a Indexed View... And It's so good... almost instant results... Thanks a lot to everyone.. Unfortunately I can only select one answer, but I sincerely thank you all for your help.
    See more | Go to post

      Leave a comment:

    • Rudurk
      replied to Making a new table from a SQL Server Query to MS Access.
      in SQL Server
      I have just been in contact with the DBA asking him if I wrote the script would he run it... and looks like his in a good mood.. bcoz his just said Yeah!!!!!.. and that he would be happy to let me have the privilege of altering it... and he'd even try to fine tune it if he can.

      :) Better result that I was expecting.
      See more | Go to post

        Leave a comment:

      • Rudurk
        replied to Making a new table from a SQL Server Query to MS Access.
        in SQL Server
        Hi Again,

        Thanks for helping me... I am going to write the view and send the script to DBA and ask him to please Run it.. I am going to try to add what JForbes has mentioned... I hope it works coz I have no way of testing the code i'll literally just have to trust that I have written it write and send it off... if it FAILS.. I am gonna be so depressed... I'll let you know of the outcome soon. Thanks a lot.
        See more | Go to post

          Leave a comment:

        • Rudurk
          replied to Making a new table from a SQL Server Query to MS Access.
          in SQL Server
          @JForbes interesting... i'll give it go and see... what happens thanks... I have never though of doing it like that before.
          See more | Go to post

            Leave a comment:

          • Rudurk
            replied to Making a new table from a SQL Server Query to MS Access.
            in SQL Server
            Oh OK.. Thanks.. Well we have asked the DBA do it before, but he didn't seem to want to do it as if he makes one for us all the other departments are gonna want the same thing.. What he did say however was.. that they could push our appointments to our server every time they create their table again.. Unfortunately my department is to scared to allow something like that, which is why I am having to go through this kind of procedure.

            ...
            See more | Go to post

              Leave a comment:

            • Rudurk
              replied to Making a new table from a SQL Server Query to MS Access.
              in SQL Server
              @Rabbit

              Access Database is Not on the same file server.. but it is on another Server.. Basically we have two servers (Probably a lot more, but one that concern us)
              Shared Information Server(SQL Server)
              Our Server(SQL Server + File Server)

              It would be really nice to know How to do it.. So I can really determine the speed for myself.. and not pursue doing something like this again.

              I have a feeling...
              See more | Go to post

                Leave a comment:

              • Rudurk
                replied to Making a new table from a SQL Server Query to MS Access.
                in SQL Server
                @Rabbit

                I realize that it won't be instant, but I think the server would create the table much faster than Access querying the server and doing it on my slow computer, and it won't be millions the server table has millions, but our department is probably must way less you gotta understand we are only one department out of 100s in our company.

                So mm do you know how to do it? Sorry for the late reply I don't work on weeke...
                See more | Go to post

                  Leave a comment:

                • Rudurk
                  started a topic Making a new table from a SQL Server Query to MS Access.
                  in SQL Server

                  Making a new table from a SQL Server Query to MS Access.

                  Hi,

                  I am working on a table that has millions of records located on SQL Server unfortunately the table is dropped and remade everyday so they don't index this table.

                  It takes a while to query this table because it is not index. It contains appointment information from all departments of course we only care about our department.

                  So when we run a query from our Access DB (Using Passthrough) it still takes...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...