I worked on a project for about three years (it was supposed to take 18 months) that still wasn't done when I left the company. They too had jumped on...

One is estimating 230000 rows and the other is estimating millions. That is either a difference in data or in stats on the data. Must be. No other options.

I had extremely limited opportunity to try SSMS 2012 against 2000, but against 2005, 2008, & 2008R2, it works great. No issues at all.

erics44 (7/31/2012)

---

Thanks

The comparrison tools are the kind of thing i was looking for

i was considering scripting the procs and stuff from the sys tables and comparing that way, building a...

GilaMonster (7/31/2012)

---

Grant Fritchey (7/31/2012)

---

But you have a vaca coming up, so...

erics44 (7/31/2012)

---

Grant Fritchey (7/31/2012)

---

Just a question, changes are getting made to the production server directly and then you need those brought down to dev and we're not talking data?

I'd say...

Looking at the plans, the first thing that jumps out is that the estimates are different between the two plans. This suggests that you either have completely different data sets...

No way to know for sure why you're suddenly seeing slow performance. Can you gather more metrics? Take a look at sys.dm_exec_requests. Can you see the backup process? Is it...

Just a question, changes are getting made to the production server directly and then you need those brought down to dev and we're not talking data?

I'd say the process is...

But you have a vaca coming up, so just turn one...

GilaMonster (7/30/2012)

---

Steve Jones - SSC Editor (7/30/2012)

---

well, as long as it's not deserted, and stocked with drinks, I vote for packing lots of books. Also currency to exchange for alcoholic...

Kishan Singh (7/30/2012)

---

I have a similar problem, there is a database in which a large table with more than 10 Million rows and on daily basis we are adding 1,32,000...

Ian Scarlett (7/30/2012)

---

I think you can (not that I'm advocating it)...

USE tempdb

GO

CREATE PROCEDURE obj_cursor @obj_cursor CURSOR...

The hard part will be the break-in. You just need the right person to see your experience (Jeff, me, others who look for that above MCSEIO) and you should be...

You can't output a cursor in SQL Server....