Oh, and one more thing - 10GB is NOT a large database. My guess is that there are MANY other things you should be doing first to improve your...

1) the first poster is incorrect. you CAN get performance increases from partitioning without multiple filegroups - sometimes vast improvements even. This would come from partition elimination during...

1) TVP is a SQL 2008 feature so this post should go on a SQL 2008 forum, not this one (SQL 2005)

2) Have you benchmarked your java application to determine...

I believe this is somewhat dependent on the index and pages therein, but it...

SanjayAttray (10/26/2009)

---

Thanks for the article, Gail.

"When an index scan is done on the clustered index, it’s a table scan in all but name."

Then why do we see index scan and...

Paul White (10/26/2009)

---

I do agree with Mr Guru there about the ORDER BY thing, but as a matter of curiosity, I think the following also guarantees a repeatable order:

WITH TS...

I think Paul is the first to get this right: it is almost certainly due to NOLOCK allowing an allocation-order scan. if you want the same rows back...

There is a lot of work to be done here, and not just on indexing. I agree with Grant - you need to get a professional engaged on tuning...

Truly a case where pictures are worth thousands of words. Nicely done.

sanokistoka (10/24/2009)

---

"works fine" = applications do not get _unexpected_ deadlocks. And I never said that SQL Server should retry transactions; what I alluded to is that it should be designed...

Piotr.Rodak (10/23/2009)

---

May I ask how it is organized then? Do you have access to...

1) define "works fine on other platforms"

2) having done that, set MAXDOP to 1 (or more likely properly tune the application with the one or more indexes that should be...

GilaMonster (10/23/2009)

---

Know your stuff backwards, forwards, inside out. Make a name for yourself in the community, blogging, writing or...

Yes, and I agree with others who said that doing so even if you do have in-house resources. Primary reason for that is that a good tuning consultant will...

Note that you must have the (very expensive) Enterprise Edition of SQL Server 2008 to use the Resource Governor.