Search Results

VB Front End Time Out Expired

Thread by: tlaurie, Feb 21, 2003, 1 replies, in forum: General DBA Questions

I have created a VB 6.0 front end to a MS SQL Server that looks at records with a disconected recordset. When the user wants to edit a record the...

Multiple Front End Users â€“ Cursors Vs. SQL

Thread by: tlaurie, Dec 20, 2002, 4 replies, in forum: General DBA Questions

When developing multiple front ends the developer faces the age old problem of two or more people trying to edit the same record. Using cursors...

MS SQL licenses vs connections

Thread by: tlaurie, Dec 16, 2002, 2 replies, in forum: General DBA Questions

What is the relationship between the number of licenses a MS Sql server has and the number of connections available? If the server only has 10...

Connection Overhead?

Thread by: tlaurie, Dec 13, 2002, 4 replies, in forum: T-SQL Performance Tuning for Developers

Let's say you have 1,000 front end users and enough resources to buy enough licenses so that all 1000 users can be connected at once to the database....

nasty Day of Week conversion

Thread by: tlaurie, Dec 12, 2002, 2 replies, in forum: T-SQL Performance Tuning for Developers

I have a table that has the day of week as a text field and is associated with a semester, not a particular date. I want to order by this field in...

# of connections problem

Thread by: tlaurie, Dec 11, 2002, 4 replies, in forum: T-SQL Performance Tuning for Developers

What do you do if you have many more front end users than connections to the SQL server available? Do you write the front end to open a connection...