Giddy up? Like this:

Or this? My wife got me out this weekend

That should work. AFAIK, the database version is the same on SQL 2005, regardless of Service Pack.

The x86 v x64 matters a lot here. Also, are you sure this instance of SQL is configured for 8GB? What's shown (Exactly) if you run sp_configure for this instance.

Great job, and a very nice read.

http://msdn.microsoft.com/en-us/library/ms188917.aspx

So you have the basic advice. Here's what I'd recommend you do right now:

1. First, make sure that you have a good full backup.

2. Switch to simple mode, then back...

I agree with Gail here. The server caches as much as it can, and holds memory as long as possible unless the OS has serious memory pressure. Even then it's...

Thanks for the update. My guess is that the R2 versions of SSIS aren't compatible with VS 2005

Embedded Express might make sense (with automated maintenance), but it would be single instance, with multiple databases. Typically people are installing separate instances of Express for applications, which is fine.

Is this on the same host that is running SQL Server?

AIX is the operating system. It's not necessarily anything that holds data. Either you have flat files (text files) or some other system of storing the data on the AIX...

A couple things

1. Are you pooling connections?

2. Are implicit transactions set on?

On the surface, a read ought to not lock for any period of time. Does this read disconnect? Is...

I think more interesting is will The Thread beat me to 30k

Nope, opposite side of the city. Not many trees out here, though I...

niall.baird (9/6/2010)

---

Without trying to derail the editorial, I really did think my wife and I were pretty much alone in the non-facebook (etc) world. Family and friends are...