6400 MB of RAM used by SQL Server on an 8 gig system. Can you confirm...

You're correct, it's valid, but pointless. SQL doesn't stop you from doing it, but it has no effect.

Basically you're saying make sure my ID exists when my ID exists....

Jeff Moden (5/1/2011)

---

I've just read a dozen articles/posts where people absolutely condemn the use of EAV's (Entity, Attribute, Value) and NVP's (Name, Value Pair) tables and lambasted anyone who stood...

GilaMonster (5/1/2011)

---

Craig Farrell (5/1/2011)

---

Badly, badly phrased. I meant drilled into it further regarding memory swaps and the like. I have a feeling he's ending up in the swapfile...

"Excuse me, waitress? I'll take my foot with ketchup...

seanhalvers (5/1/2011)

---

Glad to know there is a name for this type of thing :-D.

In regards to:

1). Yes, everything eventually rolls up to a single parent. It may seem...

Thanks Jeff. It's great to walk with you through your beer-popsicle thought process, and for all the work you did here.

I thought I was the only one who would...

Azhar, I'm surprised noone brought this up before. Latches are primarily memory...

Hey Sean.

What you're dealing with here is a Hierarchal self-join. You usually hear of them in regards to either OrgCharts, or Bills of Materials. I'm not sure what...

Syed Jahanzaib Bin hassan (5/1/2011)

---

first thing is to create script of index rebuilding from SSIS and execute 5 to 15 indexes at a time as your space and execute log...

Right, that's on the oracle side. What we need to do confirm that your ODBC driver is taking that to the SSIS as datetime. You need to look...

Interesting. So you're not using the SAN...

Well, Lutz, if it makes you feel any better, neither does mine. I forgot the order by in the correlated subquery...

You mention you use simple backups. If you have full backups and need point in time restoration capability, can compellent's snapshots deal with this? I'm assuming it can't...

STherrien-978820 (4/29/2011)

---

Well I'm a DBA first, C# developer second, web developer third, so I fully agree with a preference toward a centralized CRUD for immediate performance and centralization of logic.

My...