Quick question is it only me or has the formatting of that article gone a bit haywire. I'm sure there shouldn't be HTML formatting tags appearing alongside the SQL example.

I...

I remember some years reading an article similar to this about how to replace CURSORS with WHILE loops and the huge

debate about how much better it was for performance due...

Ok thanks I will just keep the UNIQUE non clustered index then as that can also be used in FK relationships.

I am thinking that its just not possible to add INCLUDE columns into the non-clustered index created for the PK and would have to either just use a UNIQUE constraint...

In answer to Charles request to see a script that puts all this info into use with a script that runs on a timed basis that creates a list of...

Has no-one had to move a system from 32 to 64 bit? System is windows 2003, IIS 6, ASP, SQL 20005

Just an update on some more problems I have found...

I think it must be something to do with a setting/pack or local installation setting as on my laptop at home when connecting over the VPN in management studio to...

Whats a passthrough view? Like a materialised view created on a timed job maybe?

I haven't done much work with views and I definitley don't need the data to be re-calculated...

From what I read in this article http://www.developer.com/db/article.php/3613301

there is no ALTER SYNONYM statement.

I hadn't heard about SYNONYMs and have just read an article about them.

So I would still have my two tables MATRIX_A and MATRIX_B but my SELECT statements that reference

them would...

65 milliseconds doesn't sound too long to wait.

I'm running this in SQL 2005 by the way.

Ok cheers but why would you do it this way. What would be the issue with sp_rename? Would it take too long to rename or just cause my site errors...

Very interesting information. I didn't know most of that and it explains a lot. Basically I am worrying

about nothing in the majority of these cases then.

Thanks for your input!

I don't think so as the output of the CTE is an adjaceny table where the process causing the block

has a blockingSPID = 0. Then all the processes affected by...

Yes thats a good link. Thanks