I'm thinking I might want to move the back-end to one of my Access97
applications to SQLServer instead of continuing to use Access jet but
before I start/do that I have several questions I'm hoping can be
answered as I have not yet used SQLServer for a back-end.
1. Just moving my tables from a jet back-end to a SQLServer back-end
and not changing anything else will not improve performance, True????
2. If I create pass-thru queries can they contain Access
functions(like: DatePart, CvDate, ABS, etc....) or do they need to be
pure SQL????
3. Can pass-thru queries be 'action' and 'select' queries????
4. Is there an Access add-in that will tell you which queries can
become pass-thru and which can't????
5. Is there an add-in or third party product that will convert a query
to a pass-thru query at an insertion point on a code page????
thanks
bobh.
2  2016 
On 4 Mar 2005 13:09:33 -0800, vu******@isp.co m wrote: I'm thinking I might want to move the back-end to one of my Access97
applications to SQLServer instead of continuing to use Access jet but
before I start/do that I have several questions I'm hoping can be
answered as I have not yet used SQLServer for a back-end.
1. Just moving my tables from a jet back-end to a SQLServer back-end
and not changing anything else will not improve performance, True????
Usually true. If the design already folllows good practices for C/S apps,
then you generally would see a speed improvement vs shared .mdb file on the
LAN.
2. If I create pass-thru queries can they contain Access
functions(like : DatePart, CvDate, ABS, etc....) or do they need to be
pure SQL????
They cannot contain Access or VBA functions, however, SQL Server has its own
functions that are similar.
3. Can pass-thru queries be 'action' and 'select' queries????
Yes.
4. Is there an Access add-in that will tell you which queries can
become pass-thru and which can't????
No. Short answer, though, most Access queries do not need to be converted.
Access generally does a decent job of forwarding query logic to the server for
you. A lack of pass-throughh queries is not the problem with most Access C/S
apps that are slow, it is that they retrieve large recordsets from the server
or use code loops where SQL set operations are more appropriate.
5. Is there an add-in or third party product that will convert a query
to a pass-thru query at an insertion point on a code page????
I'm not sure I understand your quesiton.
Hi Steve,
Thanks for your answer to my questions....
Q5 - I'm not sure what I meant :-)
I'll have to think onit somemore.
bobh.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Chuck Ritzke |
last post by:
I keep asking myself this question as I write class modules. What's the
best/smartest/most efficient way to send a large object back and forth to a
class module?
For example, say I have a data access module that creates a large
disconnected dataset from a database. I want to pass that dataset back to
the calling program. And then perhaps I want to send that dataset to another
class module.
At first it seems that the "object oriented"...
|
by: Jatinder |
last post by:
I 'm a professional looking for the job.In interview these questions
were asked with some others which I answered.But some of them left
unanswered.Plz help.
Here are some questions on C/C++, OS internals?
Q1 . What is the use of pointer to an array?
Q2 . What is the use of array of pointers?
Q3 . What is the use of pointer to function ?
Q4 . How to print through serial port? What is Flow Control(Xon,Xoff)
?
|
by: pandapower |
last post by:
Hi,
These were some of the interview questions asked,can someone discuss
whats the solution.
1.I have a singly linked list and i have to print the 5th element from
the last.I have to print it in a single pass of the linked list.How do
i print that?
2.If i have a structure, whose elements are an integer,a character and
a character pointer.What will be the size of the structure.Suppose on
|
by: Tony |
last post by:
Hi,
I hope I can find answers to my questions here.
1. How to execute a Private Sub in VB, from a Javascript function event.
2. How to get a JavaScript Var value from the html page and return to the VB
Codebehind.
3. If there is a way to execute a JavaScript function before the VB Code
behind page_load event.
|
by: Brian Elmegaard |
last post by:
Hi,
I am struggling to understand how to really appreciate object
orientation. I guess these are FAQ's but I have not been able to find
the answers. Maybe my problem is that my style and understanding are
influenced by matlab and fortran.
I tried with the simple example below and ran into several questions:
1: Why can't I do:
def __init__(self,self.x):
| | |
by: Nemisis |
last post by:
Hi everyone,
I have 2 classes, Company and Contact, a company can have 1 or more
contacts. A contact can only be in one company.
I have created a Company class object that contains all the properties
for my company. I have created a CompanyFactory class that has the
methods to Create, Retrieve, Update and Delete a company.
I have done the same for the Contact class and ContactFactory.
|
by: Nemisis |
last post by:
Hi everyone,
I have 2 classes, Company and Contact, a company can have 1 or more
contacts. A contact can only be in one company.
I have created a Company class object that contains all the properties
for my company. I have created a CompanyFactory class that has the
methods to Create, Retrieve, Update and Delete a company.
I have done the same for the Contact class and ContactFactory.
|
by: Setash |
last post by:
I've got a tiny bit of coding background, but its not the most
extensive.
That said, I'm trying to wrap my head around python and have a couple
questions with classes and functions.
Two notable questions:
1) Classes. How do you extend classes?
|
by: =?Utf-8?B?VGFtbXkgTmVqYWRpYW4=?= |
last post by:
Hi, I am using Visual C# window to dispaly a set of questions with their
answers. The users should be able to move to the next question by clicking on
next button. I am going to use only one panel to display one question and
move to next question. Can someone please help me with the codes on coding
"Next" button?
Thanks
--
Nejadian
|
by: Andrey |
last post by:
Hi,
I will be hiring a php guru to help us architect a highly scalable web
site/web application; the problem is I am coming from Microsoft .NET
world and not too much familiar with the platform.
What kinds of questions would you advice to ask the person on the
interview to see if he/she is:
1. Proficient with php
2. Proficient with MySQL (development, maybe some administration)
3. Has web app architecture skills and knows how to build...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
