sotn (11/8/2011)

---

Thanks for all the replies.

This is from Navision, so is out of my control, from a SQL perspective.

All I can say is that on SQL2005 it works fine for...

ionas (11/8/2011)

---

Dear Gevin,

my replies below:

1) do you have max memory for sql server set?

No, because memory is only 3 Gbytes. No min or max values.

2) Is TCP Chimney on?

No,...

It seems to be a bad estimate forcing the ORDER BY to spill to tempdb. Agree we need the actual plans.

Are you ABSOLUTELY CERTAIN you are passing the EXACT...

sotn (11/6/2011)

---

This is a very wierd, major performance issue so any help/pointers, grately appreciated.

We migrating from SQL 2005 to SQL 2008R2 SP1 64-bit, and use Navision, so we don't have...

Andy Reilly (11/7/2011)

---

Hi,

I have a query that is causing me problems. I restore the db run the sp and it takes 20+ seconds. I do nothing but Update...

1) do you have max memory for sql server set?

2) Is TCP Chimney on?

3) you need to do a file IO stall and wait stats analysis to find out where...

GilaMonster (11/7/2011)

---

Changing the clustered index to be a DESC index instead of the default...

MSQLDBA (11/5/2011)

---

Hi Friends,

One of my production server on weekly Database Maintainence job is running. That contains (updatestats, reindex,full scan and degug jobs. This job is failing last 6 months, due...

1) Never, ever, ever use SSMS GUI anything to do table object modifications. It is riddled with issues.

2) Pull your gold-standard copy of the schema out of your source...

you are gonna blow up your tlog with that single-statement insert aren't you? I wonder if it might not be faster to batch it up.

Hmm, I wonder how these set of tests will fare if the minimum open value is something like 500M, or 1.8B. Can you set up a test for where...

Who cares - it ran in one second!!! :w00t:

jspatz (11/3/2011)

---

Again .. thank you for the reply, as far as sharing the disk that we are ok with each instance gets a different slice from the san with data...

Cadavre (11/3/2011)

---

Really wasn't my intention to appear to be...

1) I LOVE the Celko bashing response! MUCH better than the simple "go away Joe" I was gonna post. 🙂

2) Hate to say this but the rownumber solution doesn't...