I have done extensive development with multiple versions VFP and SQL Server. There are several ways to do it. Give me a little more info on your application...

I know I may be beating a dead horse, but I saw this link and had to post it.

http://atheism.about.com/b/2007/02/23/you-have-freedom-of-religion-not-freedom-of-no-religion.htm

So how do they even sell hubs anymore? I think I got a good setup at home. Nice dodge on the network recommendation. jk. lol.

I kinda figured that his recommendation was to goto switches/routers, but I'm not a network guy, so I wasn't sure. I set my network up in my basement about...

I showed how their building network using cascaded hubs was a bottle neck. The brute force traffic study showed that the Network Neighborhood browser keep alive packets were accounting...

I guess the whole 'restore to point in time' would kill the multiple-databases-with-one-view-database model. I am limited on stoage and network speed, that is why I have developed the...

Why would you let a database get to 1TB in SQL Server?

Wouldn't it be easier for backups and restores to seperate each large table to it's own database, then...

It's a standalone server that hosts about 8 different applications. The biggest app has about 5000 users and we are hoping to add about 5000 more.

The way...

Ok, like, ouch. That's expensive.

You guys let me know if this sounds about right

$5,400 (ish) for SQL Server 2005 Standard x64 and 1 processor license

$4,300 (ish) for SQL Server 2005 Standard x64...

My new server is a 4 cpu quad core. In licensing terms, is that 16 processors, or is it 4?

Thanks for all of the advice. Standard edition may...

Huh, I thought the CAL licenses were per concurrent users. Didn't they used to have some kind of licensing per concurrent user? Looks like we need the per...

I got a much nicer way to do this.

1. Setup the following table:

CREATE TABLE TXTTOFILE (

LINE varchar (2000) NULL ,

IDCOL int IDENTITY (1, 1) NOT NULL

)

2. Then...

The biggest thing that I can't believe that no one has mentioned - hard drive SPEED!!

Don't get a laptop with a hard drive slower than 7200 if you can. ...

Are you really trying to use Vista for a business application? Ouch.

Using Vista for business reminds me of the old Honda/Harley motorcycle joke:

The Honda motorcycle driver rides up next...