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...

Profiler to local disk files, then load into database for analytics. Do it all the time. Very light weight going to disk. All you need is tsql/rpc...

1) this looks like it could be a VERY complex undertaking and thus is not really appropriate for a forum question. People here volunteer their time and involved questions...