Wow, I read that 3 times and I'm still not sure what you're asking. Could you possibly post the stored proc code and trigger code?

Have you looked at the execution plan of the query to see what part seems to be a bottleneck? It could be possible that an index that used to...

you may want to look into using the OVER CLAUSE with aggregate functions, I think that could simplify the number of steps you're taking to get to the IsHead column...

I typically use one of the ranking function techniques like ROW_NUMBER(), but my favorite alternative to that if you're using SQL 2005 or newer is the CROSS APPLY:

SELECT c.CustomerID, o.OrderDate,...

I'm not surprised at all. Most of the isolation levels provided by SQL Server cause way to much blocking to...

In my 18 year IT career, I've been on both sides of the fence at various companies I've worked for. At one company I was even on both sides...

Ouch! Why did I click that link? Why?

Personally I fall in the anti-C group. I did take a C class in college,...

Personally the gotcha wasn't the GO, it was figuring out if Management Studio would...

Unlike physical goods where the customer can manufacture their own replacement parts when the product is no longer supported, software is bound with a license that doesn't allow the customer...

the problem seems to be in the INSERT statement:

INSERT dbo.tblDeadLock_Log (DeadLock_Detected, DeadLock_Graph)

VALUES (@event_datetime, @deadlock_graph)

SELECT @deadlock_id = SCOPE_IDENTITY()

what's the definition of DeadLock_Graph column of this table? If that's...

this looks kinda ugly, but the best way I could figure was to find the end date ranges and go from there:

-- try partitioning by ends

WITH endings AS

...

Are you asking how you add more columns to the resultset table of the function or are you asking how you get the resultset to include more rows or some...

From what you've described,...

Have you done any work to determine what types of waits are happening on the new server? Depending on what the requests are waiting for will help determine where...

hit the key combination [ctrl] + [shift] + [R], that causes the intellisense to refresh the current window. It usually only gets the object names once when you first...