I would probably just script the views and then use Find&Replace in the script, and run it back in again.

It is not a must to use an alias. If port 1434 is open on the server then it will still work to connect to the server like SERVERNAME\INSTANCE. Otherwise...

No, they will not clash, since each temp table is created for the specific session in which it is created. If you are not using global temp tables (prefixed with...

The compile locks are used whenever SQL Server needs to recompile a plan for a procedure, or when it thinks it need to (due to clients not qualifying the name)....

Performance-wise the product will, when it is finished of course, have lots of 'hidden' improvements that will generally increase performance. Specific features you might be able to make use of...

Ok, I will try this tomorrow when I am at work where I have SQL Server 2000 (only 2005 at home). Is it always around 125, or was that just...

Latches are light-weight objects similar to locks, that are used internally by SQL Server for syncronization of (normally) very quick operations. The average wait time counter is a bit tricky...

It depends.

Temp tables are created in tempdb, just as any other real table. That means it is created and stored on disk with...

I am of course assuming that you have gone through the 'normal' ways of trying to figure it out (i.e. Google, MS Support etc) since you said the case is...

Yes, but failure to create a logon context can be caused by a lack of available memory in the MemToLeave area, where connection contexts are created. Extended stored procedures and...

Are you using extended stored procedures and/or xml processing?

You can use detach/attach process to move it. First detach the database, then move the physical (log) file(s) to the new location and finally attach the database again. When the...

Hm, sorry, no idea. I tested the statement and it worked perfectly for me. Which version of SQL Server are you using?

Did you run just that statement by itself in...

If you are thinking of starting a new project using SQL Server 2005 and Visual Studio 2005 I would definitely recommend you to try and get a hold of the...

Ehm, your SQL administrator should be pretty concerned if the log is full. But no, there is no way to delete rows without involving the transaction log. You can however...