Looks like from the plans that it is related to the increased memory and cpu available in Prod2. Prod2 plan is more efficient. I also see that you...

Hmmm. It works for me in both 2005 and 2008.

kramaswamy (3/24/2010)

---

Hi all - I have a question regarding indices and temp tables.

The situation which we are facing is this - we have a "main" table, which stores all the...

Yes, agreed. I have seen this several times here at SSC....

Chad Crawford (3/24/2010)

---

I use this on 2K5. I have a job that runs every night and stores it in a table so I can see historical trends -...

klnsuddu (3/24/2010)

---

You need to find what is causing the query you pasted to execute. Find what is causing that query to run, and then change it so that query is...

george sibbald (3/24/2010)

---

CirquedeSQLeil (3/24/2010)

---

george sibbald (3/24/2010)

---

I'm beginning to bore myself saying it but I always keep file copies of the system databases in case of loss or corruption. Saves running...

Luke L (3/24/2010)

---

CirquedeSQLeil (3/24/2010)

---

Jack Corbett (3/24/2010)

---

WayneS (3/24/2010)

---

Jack Corbett (3/24/2010)

---

I had problems with FF 3.5 so got off of it into Chrome. I don't even have FF installed now. ...

File...

Jack Corbett (3/24/2010)

---

WayneS (3/24/2010)

---

Jack Corbett (3/24/2010)

---

I had problems with FF 3.5 so got off of it into Chrome. I don't even have FF installed now. I do use...

Jack Corbett (3/24/2010)

---

I had problems with FF 3.5 so got off of it into Chrome. I don't even have FF installed now. I do use IE especially for...

GSquared (3/24/2010)

---

CirquedeSQLeil (3/24/2010)

---

mwalbert (3/24/2010)

---

good lord. 3 hours on details of DBCC commands? sheesh. seems like overkill, to say the very least.

GSquared (3/22/2010)

---

For example, I'd never bother to ask a DBA...

I find that Chrome requires much less memory. I like the ease of tab manipulation (drag and drop to new window). I also like the history window, from...

mwalbert (3/24/2010)

---

good lord. 3 hours on details of DBCC commands? sheesh. seems like overkill, to say the very least.

GSquared (3/22/2010)

---

For example, I'd never bother to ask a DBA applicant what...

If there is a single table that is more important than others, then you might want to consider the use of filegroups and piecemeal restores (as Paul alluded to in...