Didn't we have a MASSIVE thread here on SSC.com on string parsing, with amazing code samples and wonderful benchmarks??

Dynamic SQL is by far the best solution to this type of dynamic paging requirement, especially when combined with getting just the relevant keys in many-table scenarios and then getting...

iqtedar (8/4/2010)

---

We have dedicated LUN for tempdb. We never had any space issues,however we are facing some peformance issues. I wanted to specify max size of tempdb and disable autogrowth,...

I soooo prefer the CASE syntax to PIVOT! 🙂

I did learn something new, which honestly doesn't happen all that often for me when it comes to the...

Grant Fritchey is "article enough" for me, and he should be for you too. And if not, Jeff...

1) If you are tasked with maintaining a VLDB but don't have the skills/experience to do that, PLEASE have your company hire a professional to help mentor you and also...

Have you tried ProcessHacker? http://sourceforge.net/projects/processhacker/

I don't think it is bad code. Works fine to accomplish the objective. You may argue with the REQUIREMENT...

1) exactly what command is being issued to do your index maintenance on the large table?

2) are you using SORT_IN_TEMPDB option?

3) what is your tempdb IO configuration -...

sanketahir1985 (8/3/2010)

---

thanx Kevin

But i took that decision of splitting tempdb in multiple files is becoz, i was getting bufferlatch wait type

also it was indicating PAGELATCH_EX,PAGELATCH_UP also resource_Type was 2:........ and...

Sounds like you are doing this a row at a time? Can I ask why? lots of things get bad when you do row-by-row processing. Can you...

>>I do not know much about statistics and I would have thought (I dislike the word "assumed", but that is what this is) that the AUTO_UPDATE_STATISTICS setting on the database...

See here and the related 2 blog posts for some goodness on deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

I too thought at first this was a simple resource group problem. Odd how it turned out to be a DNS issue!

I am with Barry on this. Sounds like you have simple requirements and a simple solution is best. Restore backups. Or perhaps do a straight-forward implementation of...