There's no need to kill processes manually in a deadlock. When SQL picks up that a deadlock has occured, one of the processes is selected as the deadlock victim and...

And you call yourself a senior software engineer? Personally I'd consider anyone under 2 years junior.

Someone claims to...

So we do the work and you get the award? 😉

Performance tuning is an art and it's mostly trial and error. I've been doing perf tuning for close on 4...

What are you looking for?

Style differs from one programmer to another. We all have our prefered way of writing things.

Other things. Variable and class naming (where appropriate) Use of whitespace. Placing of brackets,...

That's a nice tax level. I lose around 45% of my salary to tax.

Tt's a big incentive to go solo. The tax rates for self-employed is lower to start...

Bob Fazio (11/20/2007)

---

Also, if the current PK is on the PROJ_ID which I expect it is, and assuming that it is a clustered index which is most likely the case,...

You never use CheckDB on your systems?

Index rebuilds don't need DBCC anymore (alter index ... rebuild) and most of the other DBCCs aren't needed except...

Your new query contains a correlated subquery (subselect in the select clause)

Depending on the optimiser, it's quite likely that the subquery will be executed for each row of the outer...

The second is a correlated sub query. Depending on the optimiser, it's ikely that the subquery will be executed for each row of the outer query. Essentially, it's a cursor...

Time for some polishing of the CV?

I'm in almost the...

I don't think so.

Bear in mind that SQL is a declarative language, not a procedureal one....

Ouch. I've got 447 coming up in 3 weeks. I'm not looking forward to it.

Assuming that you're using SQL 2005 (you are posting this in a SQL 2005 forum), the row number function will do exactly what you want.

select ROW_NUMBER() OVER (PARTITION BY c3...

Sure. As an example

CREATE VIEW MyView AS

SELECT Col1, Col2, Col1+Col2 AS CalculatedColumn FROM SomeTable

GO