I also remember this tool being mentioned. It changes the background color depending on the server you're connected to.

It could save some heartache if used properly.

http://www.ssmstoolspack.com/

No it doesn't, and that's the problem.

This is not the right way to code in SQL, period.

I won't go through all the problems with this here but go straight to the solution.

What business need(s) are you...

Only 1 really likely suspect.

The application is doing insert into default values. Or something like that.

This reserves them the next id. After that they run an update filling...

Always easy when you know it ;-).

EXEC [daps_linked].[db name].dbo.sp_help 'dbo.Calendar'

Same here, the thread had like 100 answer. I...

Been discussed here lately and IIRC there's no way.

SQLRNNR (8/9/2011)

---

There are a number of books out there that are worth recommending. To simplify things, I just go straight to a reading list on Amazon provided by Robert...

Please post the actual execution plan and the query. We can't help without that.

In the meantime I can recommend this reading => http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan

Right click on the group, modify group, sort.

I might suggest the sql error log to get a more precise idea of the problem. I'd be guessing at tempdb atm, but that's jsut a guess without a...

I think Breant Ozar put something out there, but that's all I can offer.

@pwalter83

This always cheers me up. I'd strongly recommend you signup to the newsletter. It's really full of great stuff (compared to most).

http://www.AppreciateLife.com

I was waiting a little bit to go there lowell (6 B rows) and distinct <seems to> always screws up the estimates. It might not be the cases if...

This install nothing on the server (but needs a separate server to log data into).

http://www.red-gate.com/products/dba/sql-monitor