Sandy2704 (5/25/2010)

---

Trasactions in our application generally range between 7 to 40 /sec......The application is not huge.....I am using a third party tool called precise i3(It gives me alert messages whenever...

Here is the Bible for this area:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.

For a table with a clustered index, if it is fragmented then doing a defrag operation (such as rebuilding the clustered index) could make the total number of pages lower....

You cannot do this. Best you...

antoniset (5/25/2010)

---

Dear Master,

I have question in my sql server 2005 64 bit, why in memmory to use very high, about 6GB sql server specification is:

1. Windows 2003 standard 64 bit

2....

Set max sql server memory to a very low value and then run very large hash joins will hit one form of memory issue. But there are MANY different...

Tara-1044200 (5/25/2010)

---

If iam want to do an INSERT and UPDATE on a table, i understrand 1 process has to wait for the other as either of them would lock the...

One addition to Gail's comments: you specifically said index rebuild and then statistics updates. That is both unnecessary and wrong if you are doing it in that order....

It is obvious to me that more pages equals lower performance in every equivalent scenario I can think of. If you are scanning you are a) having more IO...

1) this could be a cached plan that was great for the first execution but horrible for the next.

2) without the index hint, show the estimated query plan...

bobmclaren (5/24/2010)

---

I recently migrated our SQL server from a 32-bit Windows Std 2003 with only 4GB of memory to a brand new 64-bit server running Windows Server 2008 Std on...

I believe tt is normal for connections to stay around but not doing anything. But yes, the application can (and should) close it's connection when appropriate. I think...

I like Lutz's answer the best since it uses the CASE statement I prefer - although not in the way I intended it. 🙂

http://www.sommarskog.se/pivot_sp.sp could help. Erland has some really good stuff on his website.

Unfortunately I don't have the time to work this today, but shouldn't this be doable with simple CASE statements in a single pass? Hopefully someone else can work that...