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...

WayneS (9/6/2010)

---

That's not why I don't get on those sites. I'm one of those folks that are absolutely paranoid about protecting my personal identity... and all of those social networking...

I haven't done enough work with Express to frame something that I think would make sense to the MS team. If you anyone knows some experienced VS developers that struggle...

We've talked about that. We'll see as some resources should come free soon.

I didn't post it, but the link is in the editorial and here: http://connect.microsoft.com/SQLServer/feedback/details/586624/why-is-deploying-sql-server-2008-r2-sooooo-frustrating

It's...

bitbucket-25253 (9/7/2010)

---

Never been there but just slightly south of Colorado Springs is the Broadmoor resort complex ..... Always liked the "Golden Bee" that english bar...

The cell phone works at the ranch. Drops on the way out here, and if I walk across the property, I can see 3 different carriers at different places. Once...