run sp_whoisactive (find it online) while the bad query is running to see what it is waiting on or blocking.

also look at the query plan it creates - you...

something like this:

select *

from namestable n 1

where exists (select * from namestable n2 where n2.name = n1.name and n2.address <> n1.address)

1) GUIDs are a terrible design choice - fat and fragmenty (coined a new term there)!

2) no wonder your updates are getting slow - look at how many include columns...

1) the cause is often due to bugs, especially in drivers. windows 2003 had a large file copy bug that did this and HP's ILO stuff likewise. I...

I STRONGLY recommend that you get a performance tuning mentor on board for a few days to help you set things up properly and teach you some of the MANY...

GPO (12/31/2010)

---

This sort of thing does have its amusing side sometimes. An organization I used to work for hired a data warehousing "expert" to fix the mess their warehouse was...

Steve Jones - SSC Editor (12/31/2010)

---

Solomon Rutzky (12/31/2010)

---

Now, Steve mentioned "Regardless of what columns are in the nonclustered index, the clustering key is there" which is not always true. It...

Good description there Steve. One minor point - the 'uniquefier' for non-unique clustered indexes is 4 bytes, not 2.

Not sure you can ever do an apples-to-apples comparison. Sometimes one will be better, sometimes the other. Sometimes cardinality estimates will make the opitimizer pick one or the...

Hey Peter - did you make the Kansas City SQL Saturday this year? I was the speaker with the 5yo daughter in tow. 😎

1) you posted to a 10 month old thread. Please start a new one.

2) the query could be suboptimal. you may also need an index or two. ...

You did something VERY suboptimal that I have seen NUMEROUS clients do: rebuild index, reorg index, update stats. You only needed to do the first of those three...

sqldba_icon (12/29/2010)

---

Thanks Gail.I should have mentioned this before. These dbs are not heavily transactional. Lets say i have 64bit sql 2008 with OS 2008 64 bit on a 64 gb...

Nice article! I have been telling clients this stuff for 15+ years. Now I have a link I can refer them to. 🙂

Dynamics AX is hardly a well-tuned (or well designed/coded) SQL Server application from what I have heard. But there are things you can and probably should do for tuning,...