My client has a 3rd party app with SQL 2005, (using SQL, not Windows
authentication) as the backend and mostly XP Pro workstations, two with
Vista Business, all with Gigabit Nic's. Every screen that involves
database queries runs faster on the Vista's (or on the SQL server itself),
the developer says they know of know reason, and in fact don't really
support it on Vista yet. Anyone have any brilliant ideas why this may be
the case, or how to track it down? Thanks.
What the client is running on really does not matter. the SQL database is
doing all the work.
The client is merely making a connection to SQL, sending it commands to
perform actions.
What you should be concerned about is the speed of the computer running SQL.
As databases get larger and it is getting more connections from clients, is
when it gets slowed down.
Re: Dont understand what version of SQL to install ... I created a database using sql 2005 express edition. ... With that in mind - could you use SQL Server 2008 Developer Edition?... installed on Client OSs such as Windows Vista. ... (microsoft.public.sqlserver.setup)
Re: Dont understand what version of SQL to install ... but "moving" a database implies a degree of automation. ...Principal SQL Infrastructure Consultant... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... installed on Client OSs such as Windows Vista. ... (microsoft.public.sqlserver.setup)
Re: Database Server based on SQL database ... the raw database over WAN. ... So I will write a server program which receives requests from clients via ... Should I base this protocol on SQL or design my own protocol. ... ie the client doesn't have OLE DB, ADO, DAO or whatever installed - ... (microsoft.public.win32.programmer.networks)
Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add) ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server).... > 20 tables in different relations with eachother in the database,... (microsoft.public.dotnet.framework.adonet)
Re: SBS 2003 and Sql Server ~ Client Install ... but as a client, there are many applications that can act as client as already pointed out. ... Access front end to a SQL database, Excel can be a front end, A word mail merge document could access a SQL database via ODBC. ... We are trying to install the client software. ... (microsoft.public.backoffice.smallbiz2000)
