You say that the App is "still slow".  Reading your sentence in a purely logical way, are you saying that it was slow before, you did a massive hardware upgrade,...

Five concurrent queries is what it's been set to for seven years, since the first one came out (that I know of and still use) with SQL Server Version 7. ...

Can you elaborate on the setup a bit?  Are the servers distributed around the country?  Unless you're working for Ebay or Amazon, I'm missing something here.  In my experience (admittedly...

I believe Hilary's answer is mostly correct, but I also believe that it will only do half the question.  It will push the new rows to the Archive database, but...

For the past several versions, the limitations in MSDE have been in concurrent execution of queries - what MS refers to as a "throttle" on performance.  I don't have specific...

I rated this article on the low side for very simple reasons. The article covers very few points germane to it's stated purpose, and the author devotes most of...

Whether it's the Access front end, a VB app, a .net app, or script in an Excel spreadsheet, you're likely using ADO to talk to the SQL Server.  I don't...

I tend to dislike the prefix concept.  Stored Procedures are all grouped together anyway.  We all know not to use SP_, so the lack of that prefix is a standard...

We're missing the point here folks.  Whatever the original poster's design motives (good or bad), she's asking how to watch for events with an ADO connection, which is a valid...

This article was a light bulb going off for me back when it first came out.  I had not grasped the concept of multiple recordsets in ADO, and using them...

So what do other folks do when they want to share data from a SQL server amongst a large, geographically distributed group of customers?  We have hundreds of customers that...

I'm assuming from your number of posts that you have SQL Server (full version) installed somewhere in your enterprise.  You can connect to a MSDE install the same way you...

I'm watching your topic with interest, and hoping for replies from the gurus as well.  One key piece of info that would help your cause would be knowing what version...

As for the big floppy pink thing in the chest, go with the easy answer:

When in doubt, leave it out!

Works great when...

The bottom line is simple.  Always set a primary key on every table.  It can be a single field, or a combination of fields, but in either case it should...