I didn't test Jeff's code against just one partition, but from what I saw of the data when run against the whole table, I'd have to say that in that...

John Dempsey (1/28/2009)

---

I...

Can we actually purchase SQL Server 2008 Developer Edition yet. Last time I looked it still wasn't on the Microsoft website, just SQL Server 2005 Developer Edition. (Too...

My concern is actually data growth. The database may only be 2GB today, next year it could be 4GB. Seems like you end up constantly adding more hardware...

YeshuaAgapao (1/28/2009)

---

Makes sense now. I would still suggest that if the running totals requirement was the dominant form of querying on the table, I would rather just un-partition the...

I attended the AYSO Section 4 Conference in Wichita, KS last week. I learned something interesting during my Referee Administrator course and thought I'd share just a very short...

Put down the cursor and back away from the trigger...

To answer your question, I'm not sure. When I first read the headline it was like watching a train wreck,...

nairsanthu1977 (1/27/2009)

---

Fine..Last 2 fields of all the tables are common fields (Createddate and Isdeleted). thought I will keep that uniformity. Now I can' drop the tables..because system is live and...

You can't. That's why I posted a link to one thread from the other duplicates. Anyone else that now reads either of the duplicated posts will know where...

Please avoid double or triple posting your questions. It only servers to fragment any answers you may get.

Please post any replies here: http://www.sqlservercentral.com/Forums/Topic644677-338-1.aspx

Please avoid double or triple posting your questions. It only servers to fragment any answers you may get.

Please post any replies here: http://www.sqlservercentral.com/Forums/Topic644677-338-1.aspx

Adam Haines (1/27/2009)

---

Forgot to comment on the article :hehe:.

I thought the article was very informative, easy to read/understand, and offered great alternative methods to solving the "running total"...

And I must thank you in return, Jeff. If it hadn't been for you, and some of the other gurus on SSC, I never would have written this article....

YeshuaAgapao (1/27/2009)

---

I don't get this. Both of the solutions create a non-partitioned instance of the partitioned table. One form is a temp table, and the other form is...

Assumption, SSN is stored as an int. This may or may not be correct, but I had to start somewhere.

select

ID,

right('00' +...