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

Could you show us what you have done so far to resovle this problem yourself? It may be a simple fix to your code.

Count physical processors, not the number of cores in each physical processor.

Actually, Grant, I'm curious also, and with your experience with working with execution plans, your feedback on that side would be quite interesting.

Grant Fritchey (1/27/2009)

---

Uh... Wow... Over-achieve much?

I feel a bit stupid to be commenting on this. I don't have much experience with partitioning beyond reading up on the theory and a...