If you know in advance absolutely every way in which your data will ever be used, then of course some kind of dedicated data manager will be more performant than...

No, he's always like that.

If the server PC is running XP and has XP's built-in firewall turned on, this might be the problem. You need to open port... 1433 I think it is... on...

To the best of my knowledge, there is no SQL syntax you can pass to both SQL Server and Access to achieve null-to-zero functionality. While they have a lot in...

Hard to see how you'd do this purely within T-SQL. Remember the syntax for a trigger starts

CREATE TRIGGER name

ON table

so in effect the table is part of the trigger definition....

As has been stated, a plain UNION will eliminate duplicates automatically (a fact which has tripped me up more than once!). The BOL documentation is to my mind a bit...

In brief, a deadlock occurs when two transactions are blocking each other, and there is no way to resolve the situation. For example, suppose transaction X involves locking tables A...

Access (Jet) SQL queries are basically the same as T-SQL, except that 'complex' queries won't work. Saying exactly what will and won't work isn't really possible.

In terms of syntax, you...

Assuming Rides and RidesArchive have the same structure, you could just

CREATE VIEW RidesAll AS
SELECT * FROM Rides
UNION
SELECT * FROM RidesArchive

RidesAll is now a view you can query on just...

The first step is to have an *exact* idea of what you want. You said

> What I want is just the [dept] and [opid] with the largetst count.

which as far...

I would suggest that your financial-type people would be very unhappy with you altering Orders table records after orders are completed

One solution is...

>> Is there something I can do to make this perform better?

Yes. SQL Server doesn't 'know' T-SQL - help it out, tell it what you want more explicitly

>> Maybe a...

Amount user pays for customer service = zero

Tone of user = whiny and belligerent

Estimated quality of service user will receive = ???? hmmm let me ponder....

I would suggest this: Create a table that can hold all the details of the emails you wish to send. To send an email at a time-sensitive time (ie during...

I would be interested to see how the performance of this solution compares; it also does not rely on there existing consecutive dates for each ID.

I am going to recast...