Rick Heiges (5/22/2008)

---

Oracle RAC - How many companies are currently running it? If they are, how many nodes? I am not an Oracle afficiando, but I have heard...

Or, as has been sugested previously - you can do it in a set-based fashion.

this should do pretty well, especially when compared to Cursor methods. It does rely on...

oops....

However - a scheduled task that routinely looks for...

I only see a non-clustered index in what you posted. That being said - it's going to be hard to tell what is happening, without some clue as to...

In all seriousness though - this just seems to hammer even further on what is usually the weakest link in high volume systems, i.e. the storage subsystem. It seems...

Steve Jones - Editor (5/22/2008)

---

I think this is a RAC competitor, just like Scalable Shared Databases or replicating to slaves.

Log shipping existed in many installations before Microsoft built a support...

Hmm...sounds a bit like homework.

You probably want to take a look at the CASE statement, and use it appropriately in an UPDATE statement.

Anirban Paul (5/22/2008)

---

Matt Miller (5/22/2008)

---

Anirban Paul (5/21/2008)

---

I agree with Steve, not all cos are like that. My Co gave me a paid holiday trip (expenses taken care by Cos) for...

Anirban Paul (5/21/2008)

---

I agree with Steve, not all cos are like that. My Co gave me a paid holiday trip (expenses taken care by Cos) for 4 days seeing my...

Thanks...

jeff.williams3188 (5/21/2008)

---

Because then you can create your own and publish it to your own report server. Or, build a daily process to track growth by table.

And better yet, if...

jeff.williams3188 (5/21/2008)

---

You can avoid the cursor and the call to sp_spaceused using the following (stolen 😉 from the standard report 'Disk Usage by Table').

;WITH partitionStats

AS (SELECT

ps.object_id,

SUM(CASE

WHEN (ps.index_id < 2)...

Well - SQL Server 2005 has a PIVOT syntax, which would work just fine for what you're looking at.

BOL describes it all here:

http://msdn.microsoft.com/en-us/library/ms177410.aspx?wt.slv=RightRail

Please be careful not to double-post. It "dilutes" the conversation, and tends to peeve off the regulars.

Let's continue the conversation over here:

http://www.sqlservercentral.com/Forums/Topic504822-149-1.aspx