We have used Redgate with amazing results. I agree with the others - check out what is built-in first. If you need something else for replication, check...

I create a lot of SQL statements with aggregrates and trying to get multiple aggregrate values with different underlying conditions into a single statement is quite difficult and very frail. ...

A captivating hands-on how-to article.  Although I do not have a current need for such a large scale email system, I would not have thought that SQL Server would be...

The absolute quickest method and gets you as near to the production database as possible is the following:

Detach the production database, copy the .mdf file to your development machine, reattach the...

in terms of Access performance & capacity,

if you are talking "how many users" , I agree with Ian, all but the simpliest of app's won't handle more than a few simultaneous...

If you have a unique index on the history table (you should already as part of good design, I know sometimes it's not possible)  with the [ignore duplicates] option on,...

it would be helpful if you posted the solution.

This site is fantastic.  Ads are a fact of life for freebie sites.   I like the fact that the ads on this site are highly targeted and related to the...

Dear Yasir,

I post the following with some caveats.  I personallly did not write the following stored procedure, but the programming team that I manage did.  If you are experienced with...

Shawn,

You're actually more knowledgeable than you might give yourself credit.  Your current config is pretty good, so anything above this would be all the better.  You could make a career...

I installed and configured Outlook on the machine and the email features worked just fine. 

Mike

CASE is quite helpful and I use it frequently.  Think of it as a "categorization" tool, creating groups as it interprets data.  Some examples:

...

CASE

WHEN (i.status & 2048) > 0...

I've done a lot of Access to SQL Server migrations, and still many to go.  For your situation, I would recommend the following:

1. create the SQL tables and structure (take the time...

Luis,

You're asking for trouble.  My company has developed software that's been using Access runtimes since version 97 and Win95, so we've run into a lot of situations and configurations.  The only...

welcome to the world of proper indexes.  I suggest you jump in feet first.  there is a LOT of help in this forum, you should do some searches.  Also, no...