Jeff Moden (1/3/2009)

---

Oh, it absolutely is... one that is condemned by many "experts" who have yet to get it to...

TRACEY (1/4/2009)

---

Is there a benefit of doing a partition on a table to the different filegroups and this still be on the same disk i.e F

I want to visit this...

Flipping between watching Alabama get stomped, playing with 3yo daughter and surfing so not much detailed review. But is it possible that some good ol' fashioned indexing will help...

That is VERY VERY true when UDFs are involved!!! Some of...

jacroberts, I am pretty sure (>90%) that your problem can be solved with a self-join set-based solution. If the table is properly indexed that solution could well be faster...

Jeff Moden (1/2/2009)

---

Alexander Kuznetsov (12/24/2008)

---

Actually in most cases the best alternative is a loop written in a modern language such as C#, not a T-SQL WHILE loop or a CURSOR....

Actually partitioning done incorrectly can CAUSE performance problems. In addition to BOL there are quite a number of web-based resources to guide someone's study of this topic.

Still...

Tom.Thomson (1/1/2009)

---

Jeff Moden (12/31/2008)

---

Ok... now I'm getting really afraid for you guys... :hehe: you're talking about this like you use cursors and you're listening to the guy who wants to...

I wonder if poor Mr. Wagner Crivelini is aware of the recent firestorm of posts engendered by an article writer who had the audacity to take on cursors on this...

Is adding STATIC to a FAST_FORWARD cursor declaration unnecessary, redundant or worse, harmful?

Hooman Shamsborhan (12/30/2008)

---

[font="Verdana"]

Hi Again

I'm back again with a sea of troubles even in the last day of the year!!!

I tried to create PK without mentioning the filegroup at...

****

Hi Kevin,

1. I think whichever loop you use you will not notice any difference, because dbcc will run most of the time.

2. I you really need a fast loop, have...

Arindam Ganguly (12/25/2008)

---

Hi Gaby,

Thanks for the Article. It is highly helpful for our perspect. Atleast this query will be of great help for those SPs/UDFs that are badly hit by...

I have found the following two articles by Hugo Kornelios very informative with regards to cursor optimizations: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/21/curious-cursor-optimization-options.aspx and http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx.

The best help we can give you has already been given: reference Books Online (BOL). See here as a starting place for your studies: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7d913c8d-b79b-4b1f-93b9-098dd33b07a8.htm.

That link goes...