Oh, I would imagine the reason you don't see/hear much about this type of thing is that high-end companies almost always tie the hands of their consultants with NDAs that...

patrickmcginnis59 (2/25/2012)

---

TheSQLGuru (2/25/2012)

---

The scenarios I was speaking of is cases where massive IO stalls let to queries doing things like PAGEIOLATCH_xx waits - and thus not actually doing useful work....

The scenarios I was speaking of is cases where massive IO stalls let to queries doing things like PAGEIOLATCH_xx waits - and thus not actually doing useful work. That...

Also check the user SET options under which each connection executed their query. That can have an effect. Outside of that, and assuming you didn't get the execution...

GilaMonster (2/23/2012)

---

I have seen a case where the hardware was upgraded and the performance went through the floor. Terribly written code, poor design, useless indexes. On the older hardware SQL...

GuruGPrasad (2/21/2012)

---

Insert Trigger

ALTER TRIGGER [Inventory].[purchase_order_detail_FillUser]

ON [Inventory].[purchase_order_detail] AFTER INSERT

AS

SET NOCOUNT ON;

Declare @TransDetail_Id Int

Select @TransDetail_Id=purchase_order_detail_id...

Engr Shafiq (2/21/2012)

---

@TheSQLGuru:

But there is issue like when some one is updating middle record?for example max id is 10 but i want to edit id=5 then this query l not...

1) GUIDs have many VERY bad downsides for performance

2) Partitioning is a VERY advanced and complex topic. PLEASE do yourself and your company a favor and don't just read...

suresh0534 (2/6/2012)

---

I have so many Stored Procedures in my DataBase, so,How to find which Stored Procedure is taking long time in Sql Server 2005.

Because, my sql server data base slow.user's...

Let me guess - someone got happy (probably multiple times) with the DTA?? 🙂

This sounds like my typical client. I love going to places like this because there are...

This particular one is easy:

UPDATE ABCSET x= @x

WHERE ID= (SELECT MAX(ID) FROM ABC)

There are MUCH more difficult scenarios where concurrency will get you. Note this example assumes that...

Engr Shafiq (2/20/2012)

---

Jeff Moden (11/30/2011)

---

Actually, there's a great way to track it without a trigger if you can add a column as Kingston suggested. The difference is that you...

snapshot isolation as gail mentioned may be one help. I believe there is a traceflag to prevent lock escalation but that has some NASTY side-ffects. Best would be...

If you have a half-GB of tlog file on a 1.3TB drive, please don't shrink it. It will just grow back out again, leading to OS file fragmentation and...

Perry Whittle (2/20/2012)

---

Agreed, that and removing wacko maintenance plans...