Viewing 15 posts - 1 through 15 (of 33 total)
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...
November 7, 2007 at 6:29 am
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. ...
December 15, 2006 at 6:26 am
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...
November 27, 2006 at 6:54 am
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...
October 17, 2006 at 6:54 am
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...
October 5, 2006 at 6:42 am
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,...
September 15, 2006 at 6:14 am
it would be helpful if you posted the solution.
September 12, 2006 at 6:36 am
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...
September 7, 2006 at 6:05 am
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...
August 23, 2006 at 7:14 am
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...
June 6, 2006 at 6:18 am
I installed and configured Outlook on the machine and the email features worked just fine.
Mike
May 15, 2006 at 11:19 am
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...
April 25, 2006 at 6:25 am
I've done a lot of Access to SQL Server migrations, and still many to go. For your situation, I would recommend the following:
March 29, 2006 at 6:27 am
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...
September 22, 2005 at 6:41 am
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...
June 30, 2005 at 6:35 am
Viewing 15 posts - 1 through 15 (of 33 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy