We cannot help you without more details.

Scalar UDFs are the single worst performance problem I have dealt with over the last 5 years as a perf tuning consultant. I advise my clients to NEVER EVER...

tfifield (5/11/2011)

---

Ninja,

You also might want to consider how data is entered for the table. If there are VARCHAR type columns that are initially empty and then get filled in...

1) http://support.microsoft.com/kb/297861: that article is for sql 7 and sql 2000!!! WAY out of date.

2) your request for help is very deep and complex. That isn't typically what...

sequential is definitely the way to go. And there are ways you can do this in the middle tier too if you need it. With those you can...

Schadenfreude-Mei (5/10/2011)

---

TheSQLGuru (5/10/2011)

---

Clustering (and HA in general) is a VERY COMPLEX and CRITICAL subject!! You are asking questions that lead me to believe you have a very low probability...

rootfixxxer (5/10/2011)

---

Thanks for the reply.

I'll do what you suggest and come back with the results, but how do i test the file IO in the second point?

I'll let the refactoring...

One final thing: if you have Lock Pages In Memory setting enabled, you probably should consider turning that off since you have multiple instances.

That doesn't seem to be a valid query plan - it won't open in Plan Explorer. It also goes WAY beyond simple help that you get for free on...

GilaMonster (5/9/2011)

---

In general I recommend the other way around....

Sounds like a possible regression to me, although I will add the following first:

1) update stats must be done on EVERYTHING and with FULL_SCAN. no exceptions, and to do anything...

Clustering (and HA in general) is a VERY COMPLEX and CRITICAL subject!! You are asking questions that lead me to believe you have a very low probability for success....

TheSQLGuru (5/10/2011)

---

Assuming this system USED to start up successfully, SOMETHING has changed:

1) check permissions on drives, directories, files that have sql server data.

2) did someone enable windows Data Execution Prevention...

Assuming this system USED to start up successfully, SOMETHING has changed:

1) check permissions on drives, directories, files that have sql server data.

2) did someone enable windows Data Execution Prevention stuff?

3)...

run sp_whoisactive (search sqlblog.com for latest version of this AWESOME freebie) to check for blocking.